Question Locked

Excel displays ####

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When I try to change a number in a cell ( ie: 5260.00 to $5260) the number displays as ####. If I undo or press esc, it will return to the original number. What am I missing?

2 replies

by boxfiddler

is used in this case to indicate that your column is too small. Simply resize the column until the entry displays properly.

This discussion is closed to new replies.