Why do I keep getting #?

  • Thread starter Thread starter framos
  • Start date Start date
F

framos

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Display entire number in cell 3
Decimal points data not displaying as expected 2
How can I keep a zero at the beginning of a mobile number? 3
Number Formatting help 3
"if" formula not working- seems to be formatting 4
enter a number if equal to another number 4
How add a digit to front of number in each cell in excexl column 1

Back
Top