1000 separeter in Exel number

To fix the issue with the thousand separator not being accepted in Excel, you can check the following:

1. Regional Settings: Ensure that the list separator in your Windows Regional Settings matches what you are using in Excel. If the list separator is set to a different character than what you're typing in Excel, it may cause issues.
2. Excel Options: Go to Excel Options and check if the 'Use system separators' option is selected. If it is unselected, you can enable it to have Excel use the Windows Regional settings.
3. Custom Separator: If you need to use a different character for the thousand separator, you can specify it in the Excel Advanced Options.
4. Format Cells: Make sure that the cell is formatted correctly to use the thousand separator. You can do this by right-clicking on the cell, selecting Format Cells, and then choosing the appropriate number format that includes the thousand separator.

By ensuring these settings are correct, you should be able to use the thousand separator in your Excel numbers without any issues.

Excel uses the decimal and 1000 separators set in Windows.

Open the old Control Panel.

Set View top large icons at the top left.

Open the Region applet.

Click Additional settings.

On the next window, select the numbers tab, have you set the correct separators in there?