Results 1 to 5 of 5

converting euro decimal/comma to usa comma/decimal

This is a discussion on converting euro decimal/comma to usa comma/decimal within the Excel Questions forums, part of the Question Forums category; I have a spread sheet from europe and they format numbers by using the decimal first then comma ..... i.e. ...

  1. #1
    New Member
    Join Date
    Dec 2006
    Posts
    2

    Default converting euro decimal/comma to usa comma/decimal

    I have a spread sheet from europe and they format numbers by using the decimal first then comma ..... i.e. the number 22,222.22 comes from them as 22.222,22 ... my question is how do i convert the whole column back to the comma first then decimal .. i have tried highlighting the colum and going to comma but it does not work.

  2. #2
    MrExcel MVP
    Moderator

    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    9,859

    Default

    Hi Joe, welcome to the board

    Go to:

    Tools --> Options --> International (tab) and adjust Decimal and Thousands separator accordingly.

    Regards
    Jon
    Regards,
    Jon von der Heyden

    - Posting guidelines, forum rules and terms of use

    - Post your sheet using HTML tables - why?

    - Read the FAQs

    - Always use CODE tags when posting code, e.g. [CODE]insert code here[/CODE]

    - My Excel Blog

  3. #3
    New Member
    Join Date
    Dec 2006
    Posts
    2

    Default

    Thanks Jon, I tried that before and either i am doing it wrong or it is not working ...... on the spread sheet i received, i highlight the colum, then went to options, international, and that is where i think i get lost .... i am not sure what to do with the decimal box or comma box

  4. #4
    MrExcel MVP
    Moderator

    Jon von der Heyden's Avatar
    Join Date
    Apr 2004
    Location
    Blackboys, East Sussex, UK
    Posts
    9,859

    Default

    Hmmmmm, perculiar! Ok well make sure that the decimal separator is set to dot and the thousand is set to comma.

    If that doesnt work then find and replace (ctrl +H) and replace the dot with nothing. I.e. leave the "replace with" text box empty. Then do a find and replace to change all comma's to dots.

    Make sense?
    Regards,
    Jon von der Heyden

    - Posting guidelines, forum rules and terms of use

    - Post your sheet using HTML tables - why?

    - Read the FAQs

    - Always use CODE tags when posting code, e.g. [CODE]insert code here[/CODE]

    - My Excel Blog

  5. #5
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling
    Posts
    64,939

    Default

    Select the column with the data, goto Data>Text to columns..., on the 3rd step goto Advanced... and change the Decimal/Thousands seperators.
    If posting code please use code tags.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com