Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retaining column formatting
I have data that is dumped into an Excel 2002 spreadsheet
and only column A needs always to be a custom format "00000000000" so that leading zeros appear. To avoid always having to reformat the new spreadsheet I tried formatting the column and saving as a template but this did not work. I know I can accomplish this by running a macro each time, but is there not a way to always open a template with the column A formatted as desired to begin with? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retaining Formatting in 'joined' cells | Charts and Charting in Excel | |||
2007 Charts not retaining formatting | Charts and Charting in Excel | |||
Remove Hyperlinks while retaining formatting | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
Retaining text formatting in TextBox | Excel Programming |