View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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