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

EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra
DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
TaigaTaiga
Every great hero faces trials, and you—yes, YOU—are no exception!
Chat with Taiga

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