Ultimately, Excel expects you to enter text, numbers, formulas, or mathematical symbols only into its cells, so you should avoid inserting anything else—including currency symbols.

Automatic Conversion: Excel will display the currency information with a small icon next to your typed pair. Clicking this icon reveals detailed currency information.

Open your business spreadsheet in Excel 2007 and locate the cells you need to change. For example, you might have an inventory list in cells A1 through A100.