Format Round to Nearest Thousand
 

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!

--
Thanks,
GillianHG

Format Round to Nearest Thousand
 

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.

--
Kind regards,

Niek Otten

"GillianHG" wrote in message ...
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!

--
Thanks,
GillianHG

Format Round to Nearest Thousand
 

Try this:

#,\0\0\0
--

HTH,

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

"GillianHG" wrote in message
...
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!

--
Thanks,
GillianHG

Format Round to Nearest Thousand
 

Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro


"GillianHG" wrote:

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!

--
Thanks,
GillianHG