Have you ever wanted to change the default behavior of the built-in number
formats on the Formatting toolbar in Excel? Take the Currency command for example;
it is really an Accounting format masquerading as the Currency format.
The Accounting number format aligns the dollar signs to the left edge of the
cell, whereas the Currency format places the dollar sign to the left of the
The Currency, Percent, and Comma Styles on the Formatting toolbar are tied to
built-in Styles in Excel. It's just a matter of modifying the Style to change
the format that is applied when you use the associated command.
You can accomplish this task in just a few easy steps. In this example we'll
reassign the Currency command to its rightful format.
- Create a new workbook.
- On the Format menu select Style.
- In the Style Name combo box select Currency.
- Click the Modify command.
- On the Number tab select Currency, set the decimal places
to 2 if necessary, and click OK.
- In the Style dialog box click Add, then Close.
Now try it out by applying the Currency format from the Formatting
Toolbar to a number.
Keep in mind that the changes you made were only for the current workbook.
Excel doesn't have a physical file you can open and modify but you can create
a default workbook template named Book.XLT to replace the built-in defaults:
- Press Ctrl + A to select the entire workbook.
- On the Edit menu select Clear then All to clear all
data and formats.
- On the File menu select Save As.
- Change Files of Type at the bottom to Template (*.XLT).
- Name the new template Book.XLT
- Change Save in to reflect your XLStart folder and click Save.
Note: Typically the location of the XLStart folder is: ..\Program
Or if you prefer, you can specify an Alternate Startup location
for Book.XLT by selecting the Tools menu, then Options, and then
the General tab.
Note of caution! Your Startup folder for Excel was designed to open
all files located in the folder. If you create an Alternate Startup location
you may want to create a new folder rather than use a folder that already
contains Excel workbooks.