answersLogoWhite

0

This sounds like an instruction from an exercise for Excel spreadsheets.

* Select the cell or cells, row or column referred to. * Click on the Format menu and select the "cells" option. * In the option box which comes up select "number" and then select any of the numerical formats offered, or whatever format you were instructed to use. * If you select any of the numerical format.... * Number * Currency * Accounting * Percentage * Scientific

* You will get a box allowing you to control the number of decimal places displayed. The default is generally 2, but you may need to enter 2 into the box. * Click OK

User Avatar

Wiki User

16y ago

Still curious? Ask our experts.

Chat with our AI personalities

BeauBeau
You're doing better than you think!
Chat with Beau
MaxineMaxine
I respect you enough to keep it real.
Chat with Maxine
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra

Add your answer:

Earn +20 pts
Q: Change the format to display two decimal places?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Other Math

Does the control number format cause the cells to display with two decimal places so that decimal places in cells below align vertically?

The answer probably is no, because I do not believe there is any kind of Excel format called "control number." It sounds like you are asking about the number accounting format.


How do you change 225 percent into a decimal?

Not hard at all. To change a percent to a decimal, simply move the decimal to the left two places:225.0% = 2.25


To line up the currency symbols and decimal places within a column which number format should you choose?

accounting


When entering numbers in excel do you have to type in dollar signs commas or decimal places?

Dollar signs and commas are controlled through the format menu. You need to enter the decimal point. The format menu allows you to choose how many digits are to follow the decimal point. Dollar signs and commas are controlled through the format menu. You need to enter the decimal point. The format menu allows you to choose how many digits are to follow the decimal point. Dollar signs and commas are controlled through the format menu. You need to enter the decimal point. The format menu allows you to choose how many digits are to follow the decimal point. Dollar signs and commas are controlled through the format menu. You need to enter the decimal point. The format menu allows you to choose how many digits are to follow the decimal point.


What is 92.8 percent as a decimal?

Not hard at all. To change a percent to a decimal, express the percent as a decimal and simply move the decimal to the lefttwo places:92.8% = 0.928