Thread: How do I change auto formatting to allow a 0 as the first number
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 How do I change auto formatting to allow a 0 as the first number
I'm not sure what auto formatting is, but you can either change the numberformat
to a custom format (like: 00000), then do your data entry.

Or you can prefix your entry with an apostrophe: '01234

Or you could preformat the cell as Text and it'll keep anything you type as-is.

britlynd wrote:

--

Dave Peterson
Reply With QuoteReply With Quote