View original (French)

Remove the comma from numbers

Solved
nonossov Posted messages 638 Status Member -  
nonossov Posted messages 638 Status Member -
Hello my dear friends,
I need a formula that removes the comma from numbers, e.g.:
if I have: 3.2 I get 32,
33.2 ====>332
333.22====>33322
3.5555====>35555
3333.5635====>33335635
thank you very much

Configuration: Windows XP / Chrome 40.0.2214.115

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    two options:

    either remove the comma using the replace function
    select the field
    press ctrl and h
    replace: type a comma
    with: leave empty
    and replace all

    or by formula for a value in A1
    =SUBSTITUTE(A1,“,”,””)*1
    • result not guaranteed for values with an infinite number of decimal places (Excel apparently stops at an integer with 15 digits)


    thanks

    To err is human, to persist is diabolical
    7
    1. nonossov Posted messages 638 Status Member
       
      Thank you so much.
      0