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 when I type in 0 it does not show

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)

mjkbcfan wrote:

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.


--

Dave Peterson