How do you get Excel to atuomatically display a number as currency or percent?

You format the cells to currency and then when numbers are put into them, they will automatically display as currency. to format a selected range of cells in Excel, press the Ctrl-1 key combination. This will bring up a dialog box. Click on the Number tab, then choose "Currency". Choose from a large range of symbols for the particular currency you want. The click OK.