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

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.

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

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.

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

perfect thanks

"Bob Phillips" wrote:

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.