Change dots to commas!!

G

Guest

Hey

I have imported some US financial data and would need to transform the dots
to commas to be able to do calculations, i.e. 1.45667 to 1,45667

How do I do it?
 
G

Gord Dibben

Which version of Excel are you running?

2002 and newer allows you to change the dots and commas at
Tools>Options>International.

Alternative......change the settings in Control Panel>Regional and Language
Settings


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Invereted Commas 3
Formatting in formulas not allowed before commas 5
Replacing dots with commas using macro 3
How do I switch punctuation from commas to points? 1
Nobody can answer! Problem with commas and dots 19
thousand separator conversion from dot to comma 10
How to convert numbers using dots into numbers using commas 3
Losing fields after CSV conversion 4

Top