Excel+Automatically+Convert+Keyed+Numbers+to+Currency

Excel 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, if you key in the following values:‐

1123

45612

205

5

Excel 2003 will automatically convert the above to:‐

11.23

456.12

2.05

0.05

How to set it up :‐

Click ʺToolsʺ, selecting ʺOptionsʺ.

When the ʺOptionsʺ multi‐tabbed dialog box appears, click the ʺEditʺ tab.

Check ʺFixed decimalʺ.

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 or information that requires decimal places to the thousandths or ten‐thousandths for example, change this number to ʺ3ʺ or ʺ4ʺ, respectively.

Click ʺOKʺ to close the dialog box.

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