+ Reply to Thread
Results 1 to 4 of 4

198K to 198000?

  1. #1
    Registered User
    Join Date
    04-25-2005
    Posts
    5

    198K to 198000?

    I got a list where Column A is 198 and column B is K, meaning 198K, and this is about a 1600 item list. Ive been asked to convert column A to 198000, etc for 1600 different numbers.
    Is there a way to do this with formatting or a formula? Also, some of them are 107.1 meanling 107100.

    If someone could help w/ this I'd appreciate it. Thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803
    Are there other options besides K in column B? Any M's to indicate million? Any blanks to indicate that the number in column A should be left as is? Or does every entry in column A need to be multiplied by 1000? If everything needs to be multiplied by 1000 without exception, then it should be pretty easy to put the formula =A1*1000 in C1 an copy down.

  3. #3
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    An option that doesn't use formatting or formulas, assuming you want to multiply each cell by 1,000:

    enter 1000 in another cell, doesn't matter where. Copy this cell. Highlight your range of 1600 cells and Paste Special... and select Multiply.

    All cells in your range will be multiplied by 1000.

    HTH
    Bruce
    The older I get, the better I used to be.
    USA

  4. #4
    Registered User
    Join Date
    04-25-2005
    Posts
    5
    thanks. that worked. i tried them both just to see for future reference.

    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