October 18, 2012

Microsoft Excel - Why Are Hash Marks Displayed Instead of Cell Contents?

Do you know why Excel displays the # signs instead of the your text or numeric value?

There are several reasons, but the most common reason to see hash marks is because the cell is too narrow to display the value.  This happens a lot when you are trying to display a date or a sum. 

The solution - make the cell wider and your numeric value will display and the # signs will go away.

No comments:

Post a Comment