+ Reply to Thread
Results 1 to 3 of 3

How to remove separating , but keep decimal .

Hybrid View

  1. #1
    Registered User
    Join Date
    11-21-2020
    Location
    Groningen
    MS-Off Ver
    excel 2016
    Posts
    3

    How to remove separating , but keep decimal .

    Hello all,

    I am running into an issue with data downloaded from the IMF they use separating commas for each thousand number and period for decimals. The commas are formatted into the formula bar so cant be removed by formatting number and unchecking the use 1000 separators box. I also tried using the Numbervalue command but for numbers that only had a period but no comm it removed the period distorting the values in the data. Ive added the excel worksheet below. So to reiterate i would like numbers format like 1,923.25 to become 1923.25

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    10-21-2020
    Location
    pakistan
    MS-Off Ver
    2013
    Posts
    18

    Re: How to remove separating , but keep decimal .

    Select all the numbers and select format type as number. Uncheck 1000 separator option. Use simple find command and search for , and replace with nothing. Your issue will be resolved.
    Attached Files Attached Files
    Last edited by rio.south; 11-21-2020 at 07:58 AM.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: How to remove separating , but keep decimal .

    or... select all the numbers (F2:AA84). Look for the little symbol - a white square, with a yellow diamond inside and a black vertical line inside that. Click on it and select convert to number.

    The format will change to Number in Home/Number/Number. Click on Number in the DD and reselect Number. Job done.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

+ 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. [SOLVED] Remove decimal
    By itselflearn in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-30-2013, 03:22 PM
  2. [SOLVED] remove decimal from field, append what was after decimal to before
    By silent122bob in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-15-2012, 10:30 PM
  3. VBA code to remove everything after the decimal point
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-15-2011, 03:31 AM
  4. Remove Decimal Points
    By ringrim in forum Excel General
    Replies: 3
    Last Post: 08-20-2008, 08:37 PM
  5. Remove decimal and all numbers after
    By meridklt in forum Excel General
    Replies: 4
    Last Post: 07-27-2008, 03:11 PM
  6. Remove Decimal from Calculations
    By Jake in forum Excel General
    Replies: 2
    Last Post: 01-26-2005, 10:07 PM
  7. remove decimal
    By SteveRhodes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2005, 06:41 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