+ Reply to Thread
Results 1 to 3 of 3

Number format hundred to thousands

  1. #1
    Registered User
    Join Date
    06-18-2019
    Location
    Dallas, Texas
    MS-Off Ver
    windows 2013
    Posts
    72

    Number format hundred to thousands

    Good Afternoon!

    I have a list of data that represents hundred thousands, however it just says hundred values in the column. What can I used to change 100 -> $ 100,000.00 (in number formatting)

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Number format hundred to thousands

    Put 1000 in a cell. Copy it. Past Special with Multiply on your range of numbers. Format them as currency.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    06-26-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    26

    Re: Number format hundred to thousands

    You might want to check the format of the field in case the data entered is actually 100000 and just formatted to show it as in thousands.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. List with thousands of emails and I need to highlight a few hundred
    By UXResearch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-08-2019, 04:21 PM
  2. Replies: 9
    Last Post: 04-09-2018, 09:46 PM
  3. Replies: 3
    Last Post: 02-12-2017, 03:28 PM
  4. Format millions to hundred thousands
    By sabrinakr9 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-18-2015, 02:36 PM
  5. Replies: 1
    Last Post: 03-05-2015, 10:05 PM
  6. [SOLVED] Issue: Custom Number Format to Display (thousands or dashes)
    By Crawfinator1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2013, 03:28 AM
  7. [SOLVED] How do I format a number to cut off the thousands?
    By Liz in forum Excel General
    Replies: 1
    Last Post: 07-19-2006, 04:25 PM

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