How to remove comma in excel


Staff member
  1. Select the dataset (the one with the numbers)
  2. Click the Home tab in the ribbon
  3. In the number group, click on the dialogue box launcher (the small slanted arrow icon at the bottom-right part of the group)
  4. In the Format Cells dialogue box, make sure the Number tab is selected
  5. In the Category list, select Number (if not selected already)
  6. Uncheck the ‘Use 1000 Separator (,)’ option and specify how many decimal digits you want
  7. Click OK