# Formatting in 1000's

1. ## Formatting in 1000's

I use Excel 2000. Is there anyway to format numbers in 1000's? Right now I
divide each cell by 1000 to get the results I want
(=5,000,000.00/1000=5,000) and format to zero decimals.
Thanks

2. ## RE: Formatting in 1000's

You could create a Custom Format : #,##0,_);(#,##0,)

Format>Cells>Number tab
Under Category, select Custom
and enter:
#,##0,_);(#,##0,)
in the type box.

NOTE: doing that won't change the actual value of the number, so 5,000,000
will still be 5 million, but it'll look like this: 5,000

Does that help?

Regards,
Ron

"William Copeland" wrote:

> I use Excel 2000. Is there anyway to format numbers in 1000's? Right now I
> divide each cell by 1000 to get the results I want
> (=5,000,000.00/1000=5,000) and format to zero decimals.
> Thanks
>
>
>

3. ## Re: Formatting in 1000's

You can just add a comma to each of the arguments in any of the number
formats, and it will reduce the visual value by a factor of 1,000. Two
commas will reduce by 1,000,000 and so on.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"William Copeland" <ascent@cet.com> wrote in message
news:na-dnf2N1ewLg9LfRVn-tA@cet.com...
> I use Excel 2000. Is there anyway to format numbers in 1000's? Right now

I
> divide each cell by 1000 to get the results I want
> (=5,000,000.00/1000=5,000) and format to zero decimals.
> Thanks
>
>

4. ## Re: Formatting in 1000's

Yes, this works perfectly and it was so easy. Thanks.

"William Copeland" <ascent@cet.com> wrote in message
news:na-dnf2N1ewLg9LfRVn-tA@cet.com...
>I use Excel 2000. Is there anyway to format numbers in 1000's? Right now
>I divide each cell by 1000 to get the results I want
>(=5,000,000.00/1000=5,000) and format to zero decimals.
> Thanks
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1