answersLogoWhite

0


Best Answer

There is a button entitled "increase decimal". Its location depends on the version of Excel you are using.

First you must select the cell/s you wish to alter and then press the "increase decimal" button.

In Excel 2003 it is on the Formatting toolbar. It has the appearance of a small blue arrow, pointing left and is followed by a decimal point and single zero, overlying a decimal point and a double zero and looks roughly like the following:

← .0

.00

In Excel 2007 the button can be found in the following location: On the Home tab, in the Number group.

Please see related links.

User Avatar

Wiki User

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

Wiki User

12y ago

highlight cell (or cells) using left click / left click and drag

make sure the curser is over the cell, then :

right click (reveals drop down menu)

click format cells

select number tab

in category box select : number

adjust decimal places to suit

ok

>

please note ommisions added to sequence

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

You can use the format toolbar to expand the column width to fit more decimals. Example if a column is =1/3 = .3333333 it will only see .33 unless you expand width.

You may be referring to number - if you select number of the toolbar you can get column to display 0,1,2,3, etc or more decimals. Under number tab. select number then decimal places

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Not necessarily. Currency format normally has two decimal places. If your number was not in currency but already had two decimal places, then no additional decimal places would be added. If it had less than two, then decimal places would be added.

This answer is:
User Avatar

User Avatar

Wiki User

14y ago

Excel 2007:

  • Look on the home ribbon in the Number section.
  • Find two icons that shows a stack of zeros and an arrow.
  • Click on the icon with the left arrow to reduce the decimal places.
  • Click on the icon with the right arrow to increase the decimal places.

See related links for more information.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

Increase Decimal.

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

increase decimal

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

It is called the Increase Decimal button.

This answer is:
User Avatar

User Avatar

Wiki User

12y ago

Increase Decimal

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Using the button on the Formatting toolbar instructs Excel to display additional decimal places in a cell.?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How many decimals does the accounting format display in a cell in Excel?

The default is 2, but you can change the formatting to show a different amount of decimal places.


What do you click in the Conditional Formatting gallery to display the New Formatting Rule dialog box?

Click New Rule


What instructs excel to display a value as a percentage by multiplying by 100 and rounding?

percent style button


What keys do you press to display the Reveal Formatting task pane?

Shift+F1


Do formatting marks display in print preview?

Formatting marks only appear in the print preview option when you enable them in your settings. They do not, however, print on paper.


In a text handling package what is ment by formatting?

Configuring the display and output to look as you want.


How do you display a symbol in front of a field result in excel?

You can display the currency symbol in front of a result in a cell by formatting the cell for currency. When you format the cell, you can choose the currency symbol you want to display.


What is the meaning and difference between Formating Cell and Conditional Formating Cell?

Formatting sets specific configurations for a cell (e.g. make the contents bold). Regular formatting is manually configured by the user for a cell or range. Conditional formatting is applied automatically, based on some predefined criteria (e.g. if the value of the cell is negative, then display in red; if positive, display in blue).


Which features applies formatting attributes according to cell contents?

Conditional formatting can do this, and cells can also be pre-formatted so that when certain types of data are entered into them they will display in the format that you want.


What are features of formatting?

There are lots of formatting features in Excel. You have the standard ones on fonts, like size, colour, bold, italics, underline etc. Then you have ones for values, such as formatting for numbers, currency, date, percentage, scientific etc. You have built in styles that you can use. You have Autoformat, for formatting whiole tables. You also have conditional formatting, where you can formatting things based on the value in the cells. For example you could display marks in red where it is a fail in an exam and green for marks that have passed. There is formatting for other things you can create, like formatting on charts. So there are many types of formatting that Excel has available.


What is a special formatting language that programmers use to format documents for display on the Web?

Html, css, php


What function you should use to have the contents of a cell display differently based upon the value in the cell?

conditional formatting