try this, create a workbook that the columns are formatted as text then
follow the instructions below.
Automatically open a specific workbook when you start Excel
To automatically open a specific workbook when you start Excel, you can
place that workbook in the XLStart folder, or you can use an alternate
startup folder (alternate startup folder: A folder in addition to the XLStart
folder that contains workbooks or other files that you want to be opened
automatically when you start Excel and templates that you want to be
available when you create new workbooks.) in addition to the XLStart folder.
Place a workbook in the XLStart folder
Any workbook, template, or workspace file (workspace file: A file that saves
display information about open workbooks, so that you can later resume work
with the same window sizes, print areas, screen magnification, and display
settings. A workspace file doesn't contain the workbooks themselves.) that
you place in the XLStart folder is automatically opened when you start Excel.
This XLStart folder was created when you installed Excel, and is usually
located in one of the following places.
In Windows Vista, the path to the XLStart folder is usually:
C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart.
In Microsoft Windows XP, the path to the XLStart folder is usually:
C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart.
Tip You can locate the exact path to the XLStart folder in the Trust
Center.
How to locate the XLStart folder
Click the Microsoft Office Button , and then click Excel Options.
Click Trust Center, and then under Microsoft Office Excel Trust Center,
click Trust Center Settings.
Click Trusted Locations, and then verify the path to the XLStart folder in
the list of trusted locations.
Use an alternate startup folder
Click the Microsoft Office Button , click Excel Options, and then click the
Advanced category.
Under General, in the At Startup, open all files in box, type the full path
of the folder that you want to use as the alternate startup folder.
Caution Because Excel will try to open every file in the alternate
startup folder, make sure that you specify a folder that contains only files
that Excel can open.
Note If a workbook with the same name is in both the XLStart folder and
the alternate startup folder, the file in the XLStart folder opens.
Top of Page
