Thread
:
Convert decimal character
View Single Post
#
2
Ron Rosenfeld
Posts: n/a
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
Reply With Quote