software

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

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

quot;GillianHGquot; gt; wrote in message ...
gt;I posted this earlier but didn't get the answer I needed so will try again.
gt;
gt; I have a user who wants a custom FORMAT to round to the nearest thousand.
gt; (Eg if she has 104580, she wants it to round to 105000.) I tried #,##0 but
gt; it takes off the
gt; last three 0's which need to display. Does anyone know the syntax for this?
gt;
gt; She does not want to use the ROUND function; she needs the actual number to
gt; remain for calculating, she just wants to change the display.
gt;
gt; Thanks for your help!
gt;
gt; --
gt; Thanks,
gt; GillianHG
Try this:

#,\0\0\0
--

HTH,

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

quot;GillianHGquot; gt; 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
Try something like this:

lt;Formatgt;lt;Cellsgt;lt;Number tabgt;
Category: Custom
Type: #,##0,quot;000quot;

Does that help?

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

XL2002, WinXP-Proquot;GillianHGquot; wrote:

gt; I posted this earlier but didn't get the answer I needed so will try again.
gt;
gt; I have a user who wants a custom FORMAT to round to the nearest thousand.
gt; (Eg if she has 104580, she wants it to round to 105000.) I tried #,##0 but
gt; it takes off the
gt; last three 0's which need to display. Does anyone know the syntax for this?
gt;
gt; She does not want to use the ROUND function; she needs the actual number to
gt; remain for calculating, she just wants to change the display.
gt;
gt; Thanks for your help!
gt;
gt; --
gt; Thanks,
gt; GillianHG