This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Cell Formatting - Automatically Convert Keyed Numbers to Currency

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".



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Cell Formatting - Automatically Convert Keyed Numbers to Currency.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.