Format Round to Nearest Thousand

[GillianHG]

I posted this earlier but didn't get the answer I needed so will try again.

I have a user who wants a custom FORMAT to round to the nearest thousand.
(Eg if she has 104580, she wants it to round to 105000.) I tried #,##0 but
it takes off the
last three 0's which need to display. Does anyone know the syntax for this?

She does not want to use the ROUND function; she needs the actual number to
remain for calculating, she just wants to change the display.

Thanks for your help!

 

[Niek Otten]

Hi Gillian,

Use another cell with a ROUND formula instead, and hide the original.
Very misleading this, by the way. I don't know your application, but my accountant would not sign my books if he found any tricks
like this one.

 

[RagDyeR]

Try this:

#,\0\0\0
--

HTH,

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

I posted this earlier but didn't get the answer I needed so will try again.

I have a user who wants a custom FORMAT to round to the nearest thousand.
(Eg if she has 104580, she wants it to round to 105000.) I tried #,##0 but
it takes off the
last three 0's which need to display. Does anyone know the syntax for this?

She does not want to use the ROUND function; she needs the actual number to
remain for calculating, she just wants to change the display.

Thanks for your help!

 

[Ron Coderre]

Try something like this:

<Format><Cells><Number tab>
Category: Custom
Type: #,##0,"000"

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro