trailing 0's format

B

Bill

I need to format Excel 2000 cells so that every number in
a column conforms to a format that is 8 characters long no
matter what. If the number entered in a cell is 8 I want
it to be formatted so that it reads 00000008. I use
custom format and fill it in with 8 zeros and this seems
to work, but only temporarily. After I save the file and
open it up later the trailing zeros are gone. Any
suggestions how to resolve?
 
P

Paul

Bill said:
I need to format Excel 2000 cells so that every number in
a column conforms to a format that is 8 characters long no
matter what. If the number entered in a cell is 8 I want
it to be formatted so that it reads 00000008. I use
custom format and fill it in with 8 zeros and this seems
to work, but only temporarily. After I save the file and
open it up later the trailing zeros are gone. Any
suggestions how to resolve?
Click to expand...

Format the cells with the custom format 00000000
Then when you enter 8 in a cell it will appear as 00000008 and so on.
 
D

Dave Peterson

Are you saving the file as an excel workbook?

My guess is your saving it as text (or .csv).

And when you save it as text, all the nice formatting goes away--so you have
trouble when you reopen it.

Can't you just save it as an excel workbook?
 
Top