Thread: stop excel from auto editing my numbers
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default stop excel from auto editing my numbers
If you want two digits and want to see a leading zero then:

Format Cells... Custom 00


If you want an aribtrary set of digits, then begin the string with a single
quote (apostrophe)
--
Gary''s Student - gsnu200743


"HoganD87" wrote:

I type in 01, 02, 03 etc. but of course excel will turn it into 1, 2, and 3.
solution?
Reply With QuoteReply With Quote