View original (French)

CONVERTIR UN CHIFFRE US EN CHIFFRE EURO DANS EXCEL

Solved
ARTHUR03 -  
 FBC -
Hello,
Hello everyone and especially to you who are reading me.

I am looking for a macro or a tip in Excel that allows converting numbers in US format (e.g., 123,456.78) to numbers in European format (e.g., 123456,78)

Thanks in advance!
Configuration: Windows 2000 Internet Explorer 6.0

5 answers

  1.
    michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello,

    by formula:
    =CNUM(SUBSTITUE(SUBSTITUE(A1;"},";"." ) ; "." ; "," ))

    by function:
    Function convert_US(usa) As Double
    convert_US = CDbl(Replace(Replace(usa, "," , "" ), "." , ","))
    End Function

    --
    Michel
    9
    1. FBC
       
      Thank you, that’s great!
      Or, thanks to you, by macro and a custom button in the Quick Access Toolbar after selecting the cells to convert:
      For Each Cel In Selection
      Cel = Replace(Replace(Cel, ",", ""), ".", ",")
      Cel = CDbl(Cel)
      Next Cel
      0
  2. Le Pingou Posted messages 12290 Registration date   Status Contributor Last intervention   1 481
     
    Hello,
    Well, you right-click the concerned cell and choose "Format Cells" and you have all the possible options under the "Number" tab.
    --

    Best regards.
    Jean-Pierre
    2
  3. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     
    And if none of the choices (post 1) are suitable, select Category Custom, and in the small window "Type:" type #####0.00 and validate.
    --
    That’s right, retirement! Especially in the Caribbean... :-)
    Raymond
    1
  4. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 494
     
    And if none of the options (post 1) is suitable, choose Category Custom, and in the small window “Type:”, type #####0.00 and validate.
    --
    That’s right, retirement! Especially in the Caribbean ... :-)
    Raymond
    0
  6. ARTHUR03
     
    Thank you very much for your efficiency.
    0