Convert decimal character

[Guest]

I’m importing values from several web queries. Some have “.†to separate
decimals and some have “,â€. Excel considered the values with “,†as numbers,
and the values with “.†as texts so I cant calculate with them.
How can I convert “.†to “,†so they become numbers and I can calculate with
them?

 

[Ron Rosenfeld]

On Fri, 8 Jul 2005 01:47:01 -0700, "Geir Berge" <Geir

I’m importing values from several web queries. Some have “.” to separate
decimals and some have “,”. Excel considered the values with “,” as numbers,
and the values with “.” as texts so I cant calculate with them.
How can I convert “.” to “,” so they become numbers and I can calculate with
them?

You could try Edit/Replace "." with ","


--ron

 

[Bernard Liengme]

Try =VALUE(SUBSTITUTE(A1,".",","))