How to convert numbers using dots into numbers using commas

How to convert numbers using dots into numbers using commas

Post by TWFydGl » Thu, 07 Dec 2006 07:49:01


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?
 
 
 

How to convert numbers using dots into numbers using commas

Post by Gord Dibbe » Thu, 07 Dec 2006 08:32:56

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

On Tue, 5 Dec 2006 14:49:01 -0800, Martin < XXXX@XXXXX.COM >

 
 
 

How to convert numbers using dots into numbers using commas

Post by TWFydGl » Thu, 07 Dec 2006 18:43:02

Thanks! That was easily solved :-)
 
 
 

How to convert numbers using dots into numbers using commas

Post by dG9uaS5nZW » Mon, 11 Dec 2006 03:53:02

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.