when I type in 0 it does not show

M

mjkbcfan

When I type an account number beginning with 00--the zero 'sis not showing up
in the cell. Not sure the problem as it just started with this cell-no
problems prior inserting 0's.
 
D

Dave Peterson

You can preformat the cell as Text (format|cells|Number tab|Text)

or you can start the entry with an apostrophe: '001234

or you could give the cell a custom format that will show as many digits as you
want:
Format|cells|number tab|custom category
00000
(I used 5 digits)
 
M

Mike F.

Either start your number with hyphen or format the cell as a text cell. This
will allow any 0 in the beginning to show.

Mike F.
 
E

Earl Kiosterud

If these zeroes are numbers (not text), or the results of a formula, you may
need to check "Zero values" in Tools - Options - View tab.
 
Top