problem with thousands separator

**rahim84** · 06-11-2012, 04:15 AM

Hello

When working with large numbers the "thousand separator" doesnt work for the whole number, of example:

Original Number: 2800000000

Expected Result: 2.800.000.000

Result Obtained: 2800000,000.00

Please tell me what should I do for resolving this problem

**benishiryo** · 06-11-2012, 06:45 AM

hi rahim84, shouldn't it be commas instead of full stops? it should be:
2,800,000,000.00

but i don't understand how you got that result. click on the cell you want to put in the "thousand separator", & click on the comma icon seen in the Home Ribbon. It is on the right side of the percentage sign (%).

**npamcpp** · 06-11-2012, 06:54 AM

The regional settings determine if a comma or a dot is used as a thousand separator, and if a dot or a comma is used as the decimal delimiter. In most European countries, the thousand separator is a dot, and the decimal delimiter is a comma. In UK and US and many other countries, it's the other way around.

Rahim84: What are your computer settings for the decimal symbol?

In Windows XP check Start > Control Panel > Regional and language Options. Do the sample numbers look correct? If not, select a different regional setting in the drop down, or click the Customize button to use the settings you need.

In Windows 7 you can find the settings with Start > Control Panel > Clock, Language and Region > Change the date, time or number format > Additional settings.

After checking these settings, check the Excel Options (Office Button > Excel Options) and under Editing Options make sure that "Use system separators" is selected.

Does that make a difference?

**rahim84** · 06-11-2012, 07:14 AM

Thanks sir, I check my regional setting and I found that there is a wrong setting in regional tab.
thanks again.

Regards,

Abdul Rahim

**ahmad76** · 07-03-2014, 10:34 AM

Hello
I have same problem and i did all of those tips but It does'nt make diffrence

I'm sorry if i have grammer mistake

**Hussin Budiman** · 08-02-2021, 01:35 AM

Originally Posted by npamcpp

The regional settings determine if a comma or a dot is used as a thousand separator, and if a dot or a comma is used as the decimal delimiter. In most European countries, the thousand separator is a dot, and the decimal delimiter is a comma. In UK and US and many other countries, it's the other way around.

Rahim84: What are your computer settings for the decimal symbol?

In Windows XP check Start > Control Panel > Regional and language Options. Do the sample numbers look correct? If not, select a different regional setting in the drop down, or click the Customize button to use the settings you need.

In Windows 7 you can find the settings with Start > Control Panel > Clock, Language and Region > Change the date, time or number format > Additional settings.

After checking these settings, check the Excel Options (Office Button > Excel Options) and under Editing Options make sure that "Use system separators" is selected.

Does that make a difference?

i Change the separator under currency in Windows 7 Control panel Region setting . it's work for me. Thanks for the help .