| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: cannot locate default file location | Excel Discussion (Misc queries) | |||
| consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
| How do i set default column type as text in excel? | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Hybrid Mode
