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

Maybe you could format the whole column as text.

Rosewood wrote:

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?


--

Dave Peterson