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?

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 >

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 >

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.

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.

1. How to convert Decimal number with comma(,) as decimal separator to dot(.)

2. How to convert dot to comma number format?

3. How to convert Decimal number with comma(,) as decimal separator to dot(.)

4. Converting a number to a comma deliminated number (similar to currency)

5. Convert comma delimited numbers to numbers in SQL IN query

6. Converting a number to a comma deliminated number (similar to currency)

7. Using Mergefield - Convert Negative Number into Positive Number

8. how to change the dot to a comma in a list of numbers with decimals?

9. Want comma in printed numbers not dot. How?

10. use both comma and dot for decimal numbers

11. Numbers in German: comma instead of dot

12. Problem printing out numbers (currency) with commas (using Smarty or PHP)

13. Using a string of comma delimited numbers as a parameter

14. total numbers of numbers input , largest number and smallest number and average of numbers

15. How to print numbers invariably using dots as decimal symbol?

4 post • Page:**1** of **1**