=?Utf-8?Q?EXCEL:_display_number_in_'000s_i?==?Utf-8?Q?e_=C2=A315000_show_as_=C2=A315?=

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

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

"JILL" <JILL@discussions.microsoft.com> wrote in message
news:72DAEA61-E648-4FCF-B582-DC473B2DE372@microsoft.com...
> 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.

[JILL]

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" <JILL@discussions.microsoft.com> wrote in message
> news:72DAEA61-E648-4FCF-B582-DC473B2DE372@microsoft.com...
> > 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.
>
>
>