Forum Discussion
nk9961
Sep 22, 2025Copper Contributor
number format in excel
i want 1000000 to appear as 1,000,000 instead of 10,00,000. please help
ex009
Sep 23, 2025Copper Contributor
You can do this just for Excel.
1. Open Excel and go to File > Options.
2. Select "Advanced" from the left menu.
3. Scroll down to the 'Editing' options section.
4. Uncheck the option that says "Use system separators".
5. Now you can manually set:
Decimal separator: .
Thousands separator: ,
6. Click OK.