Thread: Can Excel ignore a 0 if it starts out that way
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Can Excel ignore a 0 if it starts out that way
Another option, but it'll be text numbers
Either precede the input with an apostrophe (')
or, pre-format the col as text.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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