How to convert numbers using dots into numbers using commas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 05 Dec 2006 22:49 GMT

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?

Reply to this Message

Gord Dibben - 05 Dec 2006 23:32 GMT

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

>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?

Reply to this Message

Martin - 06 Dec 2006 09:43 GMT

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
[quoted text clipped - 13 lines]
> >(e.g. 4,2). Does anyone know how can I convert the numbers into numbers that
> >use commas?

Reply to this Message

toni.gee - 09 Dec 2006 18:53 GMT

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.

> 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?

Reply to this Message

Rate this thread: