Thread: How do I enter NUMBERS with leading zeros In Excel ie 001, 002 ?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default How do I enter NUMBERS with leading zeros In Excel ie 001, 002
On Tue, 29 Aug 2006 06:46:02 -0700, bobl3517
wrote:

Thanks Ron, I tried many ways and got close in CUSTOM but entering 000
without the " " works fine. Cheers, Bob.


Sorry for the Quote confusion.

You are correct in that you should be omitting the quote marks.


--ron
Reply With QuoteReply With Quote