How do I format a number to cut off the thousands?

I need to format an entire set of financials to reflect all numbers rounded
to thousands - i.e. 1,234,567 should show up as 1,235. Any ideas??

Liz.

Try a Custom format of:

#,###,

--
HTH

Sandy
In Perth, the ancient capital of Scotland

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


"Liz" <Liz@discussions.microsoft.com> wrote in message
news:154DB278-77CD-4B6C-B176-F1911E6327B2@microsoft.com...
>I need to format an entire set of financials to reflect all numbers rounded
> to thousands - i.e. 1,234,567 should show up as 1,235. Any ideas??