answersLogoWhite

0

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

15y ago

What else can I help you with?

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 is the output if a cell containing a number 3245.45 is formatted to '?

what is the output if a cell containing number 3245.45 is formatted to '#,####'number format?


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 can a decrease decimal allow you to do?

It allows you to round the decimal fraction so as to display fewer digits.


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.