Excel format problem

[shishirshetty2701 (Shishir)]

I’m extracting the data from analytics page(basically numbers), when i fetch it and write it to excel, it gets written in “String” format due to which i’m not able to do calculation. I tried converting string to double. The calculation goes fine but “coma” disappears. I just want to know how to write the fetched string as numbers while writing to excel.

[ronanpeter]

How to convert string to double keeping "," in string as decimal separator

Hey Guys! I am facing a problem that I cannot resolve and need help. In my workflow using regex I extract numbers as a string in this format: 1234,12. Important thing is, that the “,” is the decimal separator. I have to convert this string to double type thus I can perform mathematical operations with it. When converting this string to double the new variable “drops” the “,” and results in this format: 123412. I believe the conversion omitting the “,” is due to the fact that it is considered …