[Solved] how to change number format

[bigme]

hello,
please help me, how to change number format so my number for thousand using ( . ) and decimal ( , )
in the region already same, in the advance option in the excel, but still the format doesn't change, maybe someone can help me, thank you.

 

[Lutfor Rahman Shimanto]

hello,
please help me, how to change number format so my number for thousand using ( . ) and decimal ( , )
in the region already same, in the advance option in the excel, but still the format doesn't change, maybe someone can help me, thank you.

Hello BigMe

Thanks for reaching out and sharing your problem. You want to set the Thousand Separator using period (.) and the Decimal Separator using comma (,). To do so, follow these ‍steps:

1. Press Alt+F+T to open Excel Options.
2. In the Excel Options window:
   • Click on Advanced.
   • Uncheck Use system separators.
   • Insert Comma (,) in the Decimal separator field.
   • Insert Period (.) in the Thousand separator field.
   • Hit OK.
     

Return to the sheet and apply the Comma Style, and you will see the Thousand Separator using period (.) and the Decimal Separator using comma (,) like the following GIF.

​

I hope the idea will help you. Do not skip any steps. Good luck.

Regards
Lutfor Rahman Shimanto
ExcelDemy

 

[bigme]

thank you very much...
i miss to uncheck the system separators, thank you again....

regards,
bigMe

 

[Lutfor Rahman Shimanto]

thank you very much...
i miss to uncheck the system separators, thank you again....

regards,
bigMe

Dear BigMe

You're most welcome! Thanks for thanking me.

Regards
Lutfor Rahman Shimanto
ExcelDemy