View original (French)

1.5

thefab -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

I need to be able to copy numbers from Excel to American software.

It doesn't work because in Europe we write with a comma while in the US they write with a point.

For example: 1.5 (US) 1,5 (EU).

Is there a way to convert it?

Thank you

3 answers

  1. thefab
     
    Thank you for your reply, but if I change the syntax, my Excel file no longer considers it a number, and as a result, the associated calculations no longer work.
    1
    1. fabien25000 Posted messages 697 Status Member 59
       
      re

      You can change the decimal separator in File / Options / Advanced Options
      0
      1. thefab > fabien25000 Posted messages 697 Status Member
         
        Thank you for your reply.

        Fabien
        0
  2. fabien25000 Posted messages 697 Status Member 59
     
    Hello,

    you should be able to use replace by pressing ctrl+F
    by selecting the entire workbook in advanced options

    --
    When you only have a hammer, all problems look like a nail.
    0
  3. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    error... cancelled
    eric

    By continually trying, we eventually succeed.
    So the more it fails, the more chances we have that it works. (the Shadoks)
    In addition to the thank you (yes, it happens!!!), remember to mark it as resolved. Thank you
    0