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