View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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