Rounding

The UK's most regular instructor-led training courses.
Training information: application development excel · Excel/courses/london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Rounding

Claire has attended:
Excel Advanced course

by - delegate Claire [1 post] (2008 Jun 11 Wed, 15:53) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 12 Mon	Bayswater	3	book now	£224	£224
2007	2009 Jan 13 Tue	Bloomsbury	1	book now	£224	£224
2002/XP	2009 Jan 13 Tue	Tooting	0	FULL
2003	2009 Jan 15 Thu	Southwark	1	book now	£215	£215
2007	2009 Jan 20 Tue	Bloomsbury	3	book now	£224	£224
2003	2009 Jan 20 Tue	Southwark	4	book now	£207	£215
Full Schedule: See all 134 Excel Intermediate course dates. Bookings currently available until 30th March 2010.

RE: rounding

by - trainer Carlos gold contributer [496 posts] (2008 Jun 12 Thu, 13:07) Edited on 2008 Jun 12 Thu, 13:10 Reply

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

Amount ¦ Amount (In 1,000s)

34,349 ¦ =D3/1000

and format the formula cell to 0 decimal places or ROUND it to a whole number

Hope this helps

Carlos

· Do You Really Need Excel VBA Training?
· Benefits of learning about Excel charts
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You

Please browse our web site to find out more about
application development excel and other Microsoft training courses.

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips

Rate this page: