Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excel formula or formatting to change number

    I have a column of numbers like


  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    A Custom format like:
    0.000000,,

    Will keep the values (eg 42045532), but display as if they were 1 millionth (42.045532)

    To actually convert the values, put in a cell the value 1000000, select that cell, copy it and then select the range of values, paste-special, and press divide.

    Steve

Posting Permissions

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