Forum home » Delegate support and help forum » Microsoft Excel Training and help » Rounding

Rounding

ResolvedVersion 2003

Wed 11 Jun 2008, 15:53 Delegate Claire said...

Claire has attended:
Excel Advanced course

Rounding

How do you round for eg 34,000 to 34 using a formular?

Thu 12 Jun 2008, 13:07 Edited on Thu 12 Jun 2008, 13:10 Trainer Carlos said...

RE: rounding

Hi Claire

The ROUND function does not remove the zeros (0) so 34,249 for example can only be rounded to 34,000.

What you are asking is for the number to lose a certain number of zeros, in this case 3

THis means you need to create a formula that takes the number in a cell (eg D3 and divide it by 1,000) as seen below
[b]
Amount

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Rounding

Rounding

RE: rounding

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet