Excel: Formula Returns ####

"Twenty times ten doesn't equal number sign! WTF?!"

You’ve entered a formula with the proper syntax and using valid cell references or values, but it’s just showing up as a pile of number signs. What’s going on?

What’s happened here is that the cell is too narrow. Excel will fill a cell up with number signs if it doesn’t have enough room to display the entire answer. Make the column a little bit wider, and you’ll be able to see the value.

If adjusting column width is out of the question for some reason, consider decreasing the font size, or merging cells together to give you the right amount of space.


Post a Comment