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.

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