answersLogoWhite

0

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

16y ago

What else can I help you with?

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 a column of air spinning like a roll of toilet paper to turn to a vertical position?

The conservation of angular momentum causes a spinning column of air to tilt vertically. As the air moves upward, its circulation tightens, similar to a figure skater pulling in their arms to spin faster. This tightening of circulation causes the air to turn vertically.


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 an explosion in the sky during a fireworks display?

An explosion in the sky during a fireworks display is caused by the ignition of gunpowder or other explosive materials inside the fireworks shell. When the fuse is lit, it ignites the gunpowder, creating a rapid expansion of gases that propels the shell into the air and causes it to burst, creating the colorful display of lights and patterns.