ExcelBanter - Change dots to commas!!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Change dots to commas!! (https://www.excelbanter.com/excel-discussion-misc-queries/119315-change-dots-commas.html)

Andreas

Change dots to commas!!

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?

Gord Dibben

Change dots to commas!!

Which version of Excel are you running?

2002 and newer allows you to change the dots and commas at
ToolsOptionsInternational.

Alternative......change the settings in Control PanelRegional and Language
Settings

Gord Dibben MS Excel MVP

On Fri, 17 Nov 2006 16:16:01 -0800, Andreas
wrote:

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?

All times are GMT +1. The time now is 04:19 PM.