How can I get 0000 in Every Column N every Excel file by default?

[Sanjeev]

Excel automatically truncates 00000 whenever I put 000001. I went to format
and formatted the cells. It works. But I open a new excel file...it does
again truncate 0000 from 00001.

I want to display 00001 in each and every Column. I want by default, for
evey excel file I create.

 

[Jack B]

I believe the best way to that is to make a new worksheet with 000001 and
save it as an Excel template named something like "5 zero 1".

Then, when you start Excel, go to File/New and choose "5 zero 1".


Jack

--------------------------

Excel automatically truncates 00000 whenever I put 000001. I went to format
and formatted the cells. It works. But I open a new excel file...it does
again truncate 0000 from 00001.

I want to display 00001 in each and every Column. I want by default, for
evey excel file I create.

 

[E10]

Format--->Cells--->Numbers--->Customs