EXCEL: display number in '000s ie £15000 show as £15

J

JILL

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.
 
B

Bob Phillips

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)
 
J

JILL

perfect thanks

Bob Phillips said:
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)
Click to expand...
 
Top