answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

7y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

14y ago

Change the cell formatting to currency or percent.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you get Excel to atuomatically display a number as currency or percent?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is 5 percent of 60645.00?

To find 5 percent of a number, multiply the number by 0.05. In this instance, five percent of 60645 is equal to 60645 x 0.05 = 3032.25. If the number refers to a unit of currency, don't forget to include the appropriate currency unit.


What is 6 percent of 149.00?

To find 6 percent of a number, multiply the number by 0.06. In this instance, 0.06 x 149 = 8.94. If the number refers to a unit of currency, don't forget to include the appropriate currency unit.


What is 20 percent of 64.60?

To find 20 percent of a number, multiply the number by 0.2. In this instance, 0.2 x 64.60 = 12.92. If the number refers to a unit of currency, don't forget to include the appropriate currency symbol.


What is 25 percent of 78.72?

To find 25 percent of a number, multiply the number by 0.25. In this instance, 0.25 x 78.72 = 19.68. If the number refers to a unit of currency, don't forget to include the appropriate currency symbol.


What is 15 percent of 175.00?

To find 15 percent of a number, multiply the number by 0.15. In this instance, 0.15 x 175 = 26.25. If the number refers to a unit of currency, don't forget to include the appropriate currency unit.


What is 6 percent of 147000.00?

To find 6 percent of a number, multiply the number by 0.06. In this instance, 0.06 x 147000 = 8820. If the number refers to a unit of currency, don't forget to include the appropriate currency unit.


What is ten percent of 6.20?

To find 10 percent of a number, multiply the number by 0.1. In this instance, 6.20 x 10 = 0.62. If the number refers to a unit of currency, don't forget to include the appropriate currency symbol.


What is 10 percent of 133.00?

To find 10 percent of a number, multiply the number by 0.1. In this instance, 0.1 x 133.00 = 13.30. If the number refers to a unit of currency, don't forget to add the appropriate currency symbol.


What is 15 percent of 80.40?

To find 15 percent of a number, multiply the number by 0.15. In this instance, 0.15 x 80.40 = 12.06. If the number refers to a unit of currency, don't forget to include the appropriate unit of currency.


What is 15 percent of 2500.00?

To find 15 percent of a number, multiply the number by 0.15. In this instance, 0.15 x 2500 = 375. Therefore, 15 percent of 2500 is equal to 375. If the number refers to a unit of currency, don't forget to include the appropriate currency unit.


What is 6 percent of 111.00?

To find 6 percent of a number, multiply the number by 0.06. In this instance, 0.06 x 111.00 = 6.66. Therefore, 6 percent of 111.00 is equal to 6.66. If the number refers to a unit of currency, don't forget to include the appropriate currency unit.


What is 30 percent of 233?

To find 30 percent of a number, multiply the number by 0.3. In this instance, 0.3 x 2.33 = 0.699. If the number refers to a unit of currency, don't forget to round to the appropriate number of decimal places and include the appropriate currency unit.