View original (French)

Remove the comma from numbers

Solved
nonossov Posted messages 638 Status Membre -  
nonossov Posted messages 638 Status Membre -
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 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
nonossov Posted messages 638 Status Membre
 
Thank you so much.
0