Formatting numbers
 

Change format of numbers. For example, from 20.566,70 to 20,566.70

Formatting numbers
 

This is a matter of regional settings. Either change your Windows system
settings or for one workbook you can override them (in Excel2003) by
ToolsOptionsInternational tab (I'm translating back to English, the name
may be different, it's located between Color and Save tabs), uncheck system
settings and enter desired characters in decimal separator and thousands
separator field.

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Change format of numbers. For example, from 20.566,70 to 20,566.70

Formatting numbers
 

Hi Stefi,

Thanks for your reply. It was correct but my question is different.

I make data import from another system into excel.
Ex. of import:
20,985.56
254.04
3,762.29
1,026.68
116.29

Is there any function that can transform them into:
20985.56
254.04
3762.29
1026.68
116.29

Thanks.


"Stefi" wrote:

This is a matter of regional settings. Either change your Windows system
settings or for one workbook you can override them (in Excel2003) by
ToolsOptionsInternational tab (I'm translating back to English, the name
may be different, it's located between Color and Save tabs), uncheck system
settings and enter desired characters in decimal separator and thousands
separator field.

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Change format of numbers. For example, from 20.566,70 to 20,566.70

Formatting numbers
 

I suppose that your import is of text format. This formula converts strings
to numbers if your system decimal separator is ".":

=SUBSTITUTE(A1,",","")

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Hi Stefi,

Thanks for your reply. It was correct but my question is different.

I make data import from another system into excel.
Ex. of import:
20,985.56
254.04
3,762.29
1,026.68
116.29

Is there any function that can transform them into:
20985.56
254.04
3762.29
1026.68
116.29

Thanks.


"Stefi" wrote:

This is a matter of regional settings. Either change your Windows system
settings or for one workbook you can override them (in Excel2003) by
ToolsOptionsInternational tab (I'm translating back to English, the name
may be different, it's located between Color and Save tabs), uncheck system
settings and enter desired characters in decimal separator and thousands
separator field.

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Change format of numbers. For example, from 20.566,70 to 20,566.70

Formatting numbers
 

Hi,
It works!
thanks a lot.
Regards,
Aruna

"Stefi" wrote:

I suppose that your import is of text format. This formula converts strings
to numbers if your system decimal separator is ".":

=SUBSTITUTE(A1,",","")

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Hi Stefi,

Thanks for your reply. It was correct but my question is different.

I make data import from another system into excel.
Ex. of import:
20,985.56
254.04
3,762.29
1,026.68
116.29

Is there any function that can transform them into:
20985.56
254.04
3762.29
1026.68
116.29

Thanks.


"Stefi" wrote:

This is a matter of regional settings. Either change your Windows system
settings or for one workbook you can override them (in Excel2003) by
ToolsOptionsInternational tab (I'm translating back to English, the name
may be different, it's located between Color and Save tabs), uncheck system
settings and enter desired characters in decimal separator and thousands
separator field.

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Change format of numbers. For example, from 20.566,70 to 20,566.70

Formatting numbers
 

You are welcome! Thanks for the feedback!
Stefi

€žAruna€� ezt Ã*rta:

Hi,
It works!
thanks a lot.
Regards,
Aruna

"Stefi" wrote:

I suppose that your import is of text format. This formula converts strings
to numbers if your system decimal separator is ".":

=SUBSTITUTE(A1,",","")

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Hi Stefi,

Thanks for your reply. It was correct but my question is different.

I make data import from another system into excel.
Ex. of import:
20,985.56
254.04
3,762.29
1,026.68
116.29

Is there any function that can transform them into:
20985.56
254.04
3762.29
1026.68
116.29

Thanks.


"Stefi" wrote:

This is a matter of regional settings. Either change your Windows system
settings or for one workbook you can override them (in Excel2003) by
ToolsOptionsInternational tab (I'm translating back to English, the name
may be different, it's located between Color and Save tabs), uncheck system
settings and enter desired characters in decimal separator and thousands
separator field.

Regards,
Stefi

€žAruna€� ezt Ã*rta:

Change format of numbers. For example, from 20.566,70 to 20,566.70