Change dots to commas!!

A

Andreas

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
 
Top