Best Answer

It reduces the number of digits after the decimal point in the display, rounding the number as appropriate.

User Avatar

Wiki User

โˆ™ 2016-06-13 19:27:08
This answer is:
User Avatar
Study guides





See all cards
74 Reviews

Add your answer:

Earn +20 pts
Q: What can a decrease decimal tool do in excel?
Write your answer...
Still have questions?
magnify glass
Related questions

What is decrease decimal ms excel?

It is a way to round the number(s) so that fewer digits after the decimal point are displayed.

What does decrease decimal mean in ms excel?

It means round the number so that fewer digits after the decimal point are shown.

What can a decrease decimal tool allow you to do?

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

Which button appears in Microsoft Excel toolbar only?

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.

Define decrease decimal button for excel 2007?

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.

What is the use of decrease decimal in excel?

This function has to do with the format of a cell and how many decimal places are shown. Applies only to numbers. Keep in mind that the actuall value is unchanged. For example, the number will be rounded if you specify 0 decimal places.

When you multiply decimal by decimal does it decrease?


What can the decrease decimal tool allow you to do in Microsoft Excel?

It can reduce the amount of decimal places shown. It can also make the number show in a rounded up or down format, though it will retain the actual value for use in calculations. So if you had 2.32 and decreased the amount of decimal places to one, it would display as 2.3 in a cell. It would still use 2.32 if a formula using the cell was created.

What type to software is Excel classified as and what is it primarily used for?

Microsoft Excel is an Office Productivity Tool. This tool can be used for doing Calculations.

How can you get decimal points to line up in an Microsoft Excel column?

look for the tool bar icon with the .00 and the 0.0 type thing in the upper right. click on it.

What is a Tool tip in Excel?

If you place the mouse over an icon, it will tell you what it is. This is a tool tip.

How do you split multi-worksheet Excel files into single-worksheet ones?

Excel worksheet Separator is a powerful, friendly and easy-to-use Excel tool to split multi-sheet excel files into single sheet excel files with high speed. This excel tool can easy to find you excel files and change the complicated ,duplicate and boring excel works into easy ones.

People also asked