Knowing how to fix common Excel errors like #DIV/0!, #REF!, and #NUM! can help you quickly resolve problems and save valuable time while working on your spreadsheets.

By default, Excel converts fractions that look like the month/day format into a date. For example, typing 1/2 into an unformatted cell results in the value changing to "02-Jan" (or "01-Feb" in the ...

Isolate a specific value, such as a number value in cells that contain both numbers and letters by using the Excel MID function. Click in the cell where you will display the value you want to isolate.

Microsoft Excel updates cell references when you copy an expression. Here are a couple of workarounds for those rare occasions when you don't want to change the cell references.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.