[Solved] how to change number format

bigme

Member
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,
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.
      In the Excel Options window, go to Advanced, uncheck Use system separators, and hit OK.png

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.
Thousand Separator Using (.) and Decimal Separator Using (,).gif

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

Regards
Lutfor Rahman Shimanto
ExcelDemy
 

Online statistics

Members online
0
Guests online
14
Total visitors
14

Forum statistics

Threads
292
Messages
1,268
Members
531
Latest member
lonkfps
Top