Rounding

[pete1001]

I don't think there's an answer to this but you guys never cease to amaze......

I have a sheet with lots of big numbers & formulas & want to change the display so all numbers are displayed to the nearest thousand (ie 1,234,567 becomes 1,235,000).

But, I don't want to lose underlying data within the cell(ie the 567 above) and so don't want to use the round(X,-3) function.

Is there a way using custom number format?

Pete

 

[GlennUK]

Yep,

do a custom number format of:

#,##0,",000"

and see what happens.


Cheers, Glenn.

 

[pete1001]

I knew you wouldn't let me down!

Thanks a lot.

Pete