Rounding a number to 100 Thousands (No Decimal Places)

  • Thread starter Thread starter DoctorV
  • Start date Start date
D

DoctorV

We have a user who has created Actuarial Pivot tables for 1999 - 2004.
They use a custom number format to display the data
#,###,_);(#,###,);0_)

The Problem is that by not rounding they get the following results.

Year 2000
44
144
Total

187

How can someone set a custom round function that 88,540 would come ou
as 89, 143,680 would be 144 1,700 would be 2 etc?

Thank
 
Try this custom format:

#,

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

We have a user who has created Actuarial Pivot tables for 1999 - 2004.
They use a custom number format to display the data
#,###,_);(#,###,);0_)

The Problem is that by not rounding they get the following results.

Year 2000
44
144
Total

187

How can someone set a custom round function that 88,540 would come out
as 89, 143,680 would be 144 1,700 would be 2 etc?

Thanks
 
Hi DoctorV,

Assuming your number is in A1, this formula should do what you're looking
for:

=ROUND(A1,-3)/1000

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Back
Top