How to convert numbers using dots into numbers using commas

[Guest]

I have an Excel sheet with a specific range of cells that contain numbers.
The format of these cells is "General" (so not "Number").

The numbers in these cells use dots (e.g. 4.2) while I work with commas
(e.g. 4,2). Does anyone know how can I convert the numbers into numbers that
use commas?

 

[Gord Dibben]

If your system is set to use commas as decimal point you should be able to
select the range of cells with dots and Edit>Replace

what: dot(.)

with: comma(,)

Replace all.


Gord Dibben MS Excel MVP

 

[Guest]

Thanks! That was easily solved

If your system is set to use commas as decimal point you should be able to
select the range of cells with dots and Edit>Replace

what: dot(.)

with: comma(,)

Replace all.


Gord Dibben MS Excel MVP

 

[Guest]

Whilst it may not be immediately relevant to your problem, Finland uses a
comma for the decimal separator (and a space for the thousand separator).
Selecting Finland in the Regional and Language Options of Control Panel would
display all numbers in this format as standard.