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

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.

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

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

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

"Sanjeev" wrote in message
...
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.

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

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

"Jack B" wrote:

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

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

"Sanjeev" wrote in message
...
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.