decimal separator?

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hi,

I'm using web quiries to obtain data from web pages. Some of the sites
use ',' as a desimal separator others use '.'. I'm from Finland so I'd
like to use ',' as decimal separator. Is there a way to format those
U.S.-format('.') numbers to Finnish-format(',') without changing the
setting for the whole progmam/operating system??

Thank you,
Jimmy
 
format the cells where you will paste as text

paste in the data

format the cells a general

do edit=>Replace
Replace what .
replace with ,
 
Back
Top