Number formatting - Placement of commas

The issue you're facing is due to the formatting of numbers in Excel, specifically the use of commas as thousand separators. It seems likie your Excel is set to use the Indian numbering system, where commas are used to separate lakhs (100,000) instead of thousands.

To fix this, you can try the following:

1. Select the cell(s) with the number.

2. Right-click on the selected cell(s) and choose "Format Cells."

3. In the Format Cells dialog box, click on the "Number" tab.

4. In the Category list, select "Number."

5. Uncheck the box next to "Use 1000 Separator (,)" or select a different separator if needed.

6. Click "OK" to apply the changes.

Alternatively, you can also try changing the regional settings in Excel:

1. Go to File > Options > Advanced.

2. Scroll down to the "Number"i section.

3. Uncheck the box next to "Use system separators" or select a different separator if needed.

4. Click "OK" to apply the changes.

Source: Meta AI

Can anyone suggest me the best YouTube (any other video) video playlists for mastering Excel & powerpoint? TIA

hope you are not using pirated version(bugs inbuilt)