number format in excel

Use this custom format.

Hey mate!

Option 1: Change Windows/Excel Regional Settings

1. Open Control Panel → Region (or "Time & Language" → "Region" in Windows 10/11).
2. Click Additional settings….
3. Under the Numbers tab, set the Digit grouping to 123,456,789 (instead of 12,34,56,789).
4. Click Apply and OK.
5. Restart Excel — numbers will now appear as 1,000,000.

Option 2: Custom Number Format in Excel

1. If you don’t want to change system settings:
2. Select the cell(s).
3. Press Ctrl+1 (or right-click → Format Cells).
4. Go to Number → Custom.
5. Enter this format:

   #,##0
   or
   #,##0.00

   depending on whether you want decimals