Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Cell Formatting

Automatically Convert Keyed Numbers to Currency

Summary: Need to enter a huge series of dollar amounts into a Microsoft Excel 2003 spreadsheet? This tweak can save you from typing the periods between dollars and cents.

If you need to key in a huge selection of currency values into your Microsoft Excel 2003 spreadsheet, not having to key in the decimal point can save you many keystrokes. You can tweak Microsoft Excel 2003 to automatically add decimal points to all numbers entered. For example, after performing this tweak, if you key in the following:

1123
45612
205
5

Microsoft Excel 2003 will automatically convert the above to:

11.23
456.12
2.05
0.05

1. Click "Tools", selecting "Options".

2. When the "Options" multi-tabbed dialog box appears, click the "Edit" tab.

3. Check "Fixed decimal".

4. Next to "Places", you can customize the number of decimal places for all keyed numbers, if desired. For currency this should remain "2", but if you are typing in other types of information that requires decimal places to the thousandths or ten-thousandths, for example, change this number to "3" or "4", respectively.

5. Click "OK" to close the dialog box.

To later disable this functionality, repeat the above steps but uncheck "Fixed decimal".

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Cell Formatting page.

Print this tip.

- Subscribe!

Search the Site: