Forgot to mention to open a new workbook. Adjust the settings as required and
save as Book.xlt..Refer the KB article below

http://office.microsoft.com/en-us/ex...292861033.aspx

"Jackpot" wrote:

One way is to create a template and name it "Book" . If you already have the
Book.xlt in the XlStart folder all new workbooks are created from this
template.

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART


"Eric" wrote:

Does anyone have any suggestions on how to set the default format on excel
2003? such as font, size, center align, whenever I open, it is all set.
Thanks in advance for any suggestions
Eric