+ Reply to Thread
Results 1 to 3 of 3

How to change format of numbers (thousand and decimal separator)?

  1. 04-16-2021, 05:50 AM #1
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    How to change format of numbers (thousand and decimal separator)?

    Good morning.
    I've downloaded data of SBF 120 from 2010 until 2020 from the website investing.
    The problem is that I can't change the format of my data.
    I have this type of number: 4,410.14. I can't make calculation with this format. I have the message #VALUE.
    I want to change to this type of number: 4.410,14

    Thank you for your help.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Luu4466; 04-16-2021 at 06:45 AM.
    Reply With QuoteRegister To Reply
  2. 04-16-2021, 06:00 AM #2
    bebo021999
    bebo021999 is online now
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,449

    Re: How to change format of numbers (thousand and decimal separator)?

    HIghtlight the range
    Ctrl-H (Find and replace)
    Find what:,
    Replaced with:
    OK

    (Find colon(,) and Replace with nothing (leave it blank)
    Quang PT
    Reply With QuoteRegister To Reply
  3. 04-16-2021, 06:44 AM #3
    Luu4466
    Luu4466 is offline
    Forum Contributor
    Join Date
    11-07-2020
    Location
    Paris
    MS-Off Ver
    Microsoft office 365
    Posts
    175

    Re: How to change format of numbers (thousand and decimal separator)?

    Thank you bebo021999.
    I withdrew , and . from my numbers. I obtained 441014 then I divided 100. I obtained 4410,14.
    I can make my calculation now.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Format numbers to include dollar sign and thousand separator
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-16-2016, 01:36 AM
  2. Change decimal separator format in a wokbook
    By poseido in forum Excel General
    Replies: 0
    Last Post: 09-01-2011, 10:56 AM
  3. Using formula in cell - thousand and decimal format does not work
    By anstasija in forum Excel General
    Replies: 2
    Last Post: 08-15-2011, 01:52 AM
  4. Mixup between thousand separator and decimal point in Eurpeean Excel.
    By Jiser001 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-02-2009, 05:11 AM
  5. "Format"? Problem with thousand separator
    By Andres Cadiz in forum Excel General
    Replies: 1
    Last Post: 01-08-2008, 06:16 PM
  6. [SOLVED] How to change decimal separator . to ,
    By MG in forum Excel General
    Replies: 2
    Last Post: 03-03-2006, 08:45 AM
  7. How do I change the way the decimal separator displays?
    By chiuam in forum Excel General
    Replies: 2
    Last Post: 01-20-2006, 04:00 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1