View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default can i change the default cell format to text in a new document

i am dealing with product numbers that start with leading zeros. Excel by
default treats these as numbers, and leaves out the zeros.
Is there a way to set the default format in a new document to text, so that
excel will keep those zeros?
thanks
jay