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.