View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Rosewood
 
Posts: n/a
Default Stop excel from dropping the 0 in the beginning of a number?

I do a lot of spreadsheet with number that start with one or more zeros. Not
matter how many times I change the cel format to "text" so that the zeros are
not dropped, I find that as I go down the sheet, they are dropped and I have
to re-format the cels to "text" and replace the zeros.

How can I stop the program from dropping the initial zeros?