+ Reply to Thread
Results 1 to 4 of 4

Formatting in 1000's

  1. #1
    William Copeland
    Guest

    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. #2
    Ron Coderre
    Guest

    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. #3
    Ken Wright
    Guest

    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. #4
    William Copeland
    Guest

    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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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