Why do I keep getting #?
 

Whenever I type in a two digit number it automatically turn to a #. The
formula bar still reads the number, but it displays # in the cell. If i type
in a single digit number, it will display correctly. I tried to expand the
cell to allow more room, and switched the format from general to number, to
no avail. Any ideas? Thanks.

Why do I keep getting #?
 

Did you widen the column enough?

Did you shrink the font size?

framos wrote:

Whenever I type in a two digit number it automatically turn to a #. The
formula bar still reads the number, but it displays # in the cell. If i type
in a single digit number, it will display correctly. I tried to expand the
cell to allow more room, and switched the format from general to number, to
no avail. Any ideas? Thanks.

--

Dave Peterson