Thread: Can Excel ignore a 0 if it starts out that way
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Can Excel ignore a 0 if it starts out that way
format the cell with a custom format of

0000000

Note however that the cell hold the value 23408 and that only the format of
the cell has changed.
--
HTH...

Jim Thomlinson


"Cali Tech" wrote:

I am trying to create a spread sheet and need to enter 0023408 and it wants
to put 23408. I need the 00 to be there. How can I turn this feature on or
off.
Reply With QuoteReply With Quote