It is called the Increase Decimal button.
It displays numbers with more digits after the decimal point.
It increases the number of digits displayed after the decimal point. It will not change the value of the number.
The number in the relevant cell is displayed with more digits after the decimal point.
Where a number is showing some decimal points and you want to decrease the amount of decimal points it shows, you can use the decrease decimal button to do it. Each time you click it, it will remove one decimal place until you have the amount you want or all are gone. There is also a corresponding increase decimal button, which does the opposite.
It has an arrow pointing to the left and then a dot and a zero beside it and under them it has a dot and two zeros. This indicates that in has gone from having one decimal point to having two decimal points.
There are several buttons that appear on Excel toolbar but not on other office toolbars, a few are conditional formatting, increase decimal, and decrease decimal.
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.
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.00In Excel 2007 the button can be found in the following location: On the Home tab, in the Number group.Please see related links.