Round to Thousands
Round to Thousands
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Round to Thousands

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Louisiana U.S.A.
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am trying to format a whole column to round each cellís contents to the nearest thousand. EXAMPLE: 5,132,982 would read 5,133 and 3,312,013 would read 3,312 etc. I do not want to divide each number by 1000. Is there a way to highlight the whole column and perform some customized formatting that will give the intended result?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think you'll need to round first
    =ROUND(A1,-3)
    then apply a custom format such as
    #,###,

    good luck

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Bushkill, PA
    Posts
    54
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can type 1000 in an empty cell, copy it, highlight the column or the cells you want to adjust. Do paste special and select the divide button. Then format it to drop decimal and you are done.

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Louisiana U.S.A.
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ††
    Thanks,
    All of the above work well.

    Henry G.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

DMCA.com