View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How to convert comma to dot

If you are importing the data you could temporarily change your Regional
Settings (or Excel Option) to have decimal separator as comma, import the
data and then reset the decimal separator to period.

If it is too late for this:
Let the number be in A1
In B1 extract the integer part with: =--MID(A1,1,FIND(",",A1)-1)
in C1 find the fractional part with: =--MID(A1,FIND(",",A1)+1,256)
Note that the double negation converts text to number
Combine the two in D1 with: =B1+C1/10^LEN(C1)

If you wish you can then copy the value in D1 and use Paste Special with
Values specified to turn the formula into a number. This lets you delete the
B and C stuff

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Olinia" wrote in message
...
How to convert comma to dot for data?