View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave B. Dave B. is offline
external usenet poster
 
Posts: 10
Default Turning off auto formatting

I am using several excel sheet to report on a rather large PO system. Many
customers have preceding zeros on their POs, while others do not, and being
that different customers have several different numbering systems, I cant
just arbitrarily format all cells a certain way. So,to avoid further
headaches, can I diable the built in formatting that wants to delete
preceding zeros? If so, can someone tell me how this is done please.
Thankyou.