Replacing "." with ","

  • Thread starter Thread starter teeshappy
  • Start date Start date
T

teeshappy

Hi,

I have a program that imports external numerical web-data to an exce
file. The numerical data is refreshed and changes every 2 seconds.

Numbers imported without a decimal place contain "commas", i.e. 4,0
and 16,00.

Numbers imported with a decimal place contain "points", i.e. 4.20 an
16.50.

My version of Excel recognizes numbers with a "comma" but not with
"point". Therefore the imported data with a "point" is useless to me
My pc and keyboard are Swedish.

I've tried replacing the "point" with a "comma" for the cell
concerned, but as the numbers are refreshed every two seconds th
numbers revert to a number with a "point" in it.

Does anyone have any ideas on how to convert the numbers with a "point
in them to numbers with a "comma" in them? I've spent several hours o
this and it's driving me crazy!!

Thanks for your time, and for any ideas!

Dav
 
Hi teeshappy

I've not tested this but it should work.

Before importing the data.

Start > Settings > Control Panel > Regional Settings
Change your country to (eg) United States
Apply
Import the data
Start > Settings > Control Panel > Regional Settings
Change your country back to Sweden
Apply.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Norman,
Thanks for that, I see now that it wasn't an Excel problem. Work
perfectly now.
Be lucky
 
Back
Top