Convert decimal character

G

Geir Berge

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?
 
R

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?
Click to expand...

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


--ron
 
Top