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

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

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

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Geir Berge" <Geir wrote in message
...
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?