answersLogoWhite

0


Best Answer

For a single cell: with the cell selected, Format menu > Cells > Number tab > Category: Number [By default the Decimal places is set to 2] > OK.

To apply this format to a whole column: position the mouse icon over the column heading (such as B); the icon becomes a black arrow pointing down. Click to select the column, then use the Format menu as above.

To apply this format to a range of cells: select the range, then use the Format menu as above.

You can also adjust the horizontal position of figures within a cell: select the cell(s), then Format menu > Cells > Alignment tab > explore the options under Horizontal, especially Right (Indent) with Indent set at 1 or 2.

When one cell has just the right format, you can apply its format to one or more other cells using the Format Painter. Select the "perfect" cell, then click the paintbrush icon in the Formatting toolbar, then click another cell to apply the format without changing the value in the cell. If you double-click the Format Painter, you can go on "painting" cells as long as you like. To exit, press Esc on your keyboard or click the Painter icon again.

User Avatar

Wiki User

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

Wiki User

14y ago

The format is actually called Number format. It defaults to two decimal places. However, in all cases where you have the same number of decimal places, any of the number formats will align the decimal point vertically. Both Currency and Accounting will also use two decimal places as the default.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

The forat causes the cells to display with two decimal places so that decimal places in cells below align vertically?

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

Yes, as long as the cell entry contains numbers.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Yes.

Yes.

Yes.

Yes.

Yes.

Yes.

Yes.

Yes.

Yes.

Yes.

Yes.

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Format / Cells / Number / Decimal Places: 2

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Format > Column > Right

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Yes.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Does the accounting number format causes the cells to display with two decimal places so that decimal places in cells below align vertically?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What Format causes the cells to display with two decimal places so that?

accounting number


What effect does the Accounting Number Format have on selected cells?

causes cells with two decimal places to align vertically correctly


What format causes the cells to display two decimal places?

Setting the number of decimal places, in the number format, to 2.


What Format causes the cells to display the cell result to two decimal places?

Yes, but you can then change the amount of decimal places you see.


What effect does the accountng number format have on the selected cells?

The accounting format sets the figures into currency and sets their alignment in a standard way so that the currency symbol is always positioned in the same place as it is in all values. Currency format always puts the currency symbol right beside the numbers, so they are not always in the same position in relation to the other figures.


What causes the most earthquakes?

Earthquakes that causes most damage when two plates crashed and one plate moves upwards vertically than the other plate.


Why is an earthquake extreme?

Earthquakes causes a miassive display of DISTRUCTION.


What causes the change in the display of constellation in the sky in one year?

star


What causes the soil and rock to fall?

When the ground thaws, the force of gravity causes the soil and rock particles to fall back down. But they fall vertically, toward the center of Earth. The result is movement downhill.


What effect does the comma style format have on selected cells?

It puts commas in to break the groups of thousands. They are sometime called thousand separators. Before being formatted you could have a number like 16777216. When it is formatted to the comma style it will appear as 16,777,216.00 including the two decimal points at the end. They can be removed if you wanted.


What causes the soil and rocks particles fall?

When the ground thaws, the force of gravity causes the soil and rock particles to fall back down. But they fall vertically, toward the center of Earth. The result is movement downhill.


What causes the soil and rock particles to fall?

When the ground thaws, the force of gravity causes the soil and rock particles to fall back down. But they fall vertically, toward the center of Earth. The result is movement downhill.