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.

Trending Questions
Which is faster the current WiFi standard or Gigabit Ethernet 1000BaseT What real world issues might affect actual speeds for each technology? Which of these items should be cleaned on the smart card printer? Character that displays on the screen but isn't visible in a printed document? A computer with a host IP address of 10.10.5.1 sends a data packet with a destination IP address of 10.10.5.2 A subnet mask of 255.255.255.0 is being used Determine whether the packet stays in the? What is MSconfig command? Describe an example of how you used your proficiency in computer technology and programs such as those in the Microsoft Office Suite or similar programs to solve a problem? How can you disable an embedded component on the motherboard? What contains all configuration data about the computer including information about device drivers and devices used at start up? Why should you not store a lot of data in a spreadsheet? What do you file immediately after bogart? Which command temporarily changes your access rights to those of another user? When a nonnumeric field is added to a PivotTable it is placed in the? How many gallons of water are in the Southern ocean? Does the way testing Listening differ from testing Reading? Is max your computer download any good? Why do your imported videos only play sound and no video? What does a person mean by 72bpi image? When using paypal card at any ATM is fee free? Where does Where does sharepoint store the index file for the search feature? Which document is most efficiently created in spreadsheet software?