You can us a custom format to do that without affecting the real value

0,;-0;0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JILL" wrote in message
...
Trying to find function that will take number and round down and show as
multiple of 1000's. ie. £15000 will show as £15. MROUND does not seem to
be
the right formula.