Removing Dollar Sign by Using the Format Cells Dialog Box


Staff member
  1. Select the cells containing the dollar signs that you want to remove
  2. Right-click on your selection and click “Format Cells” from the popup menu.
  3. This will open the Format Cells dialog box. Select the “Number” tab.
  4. Under the Category list, select the ‘Currency’ option.
  5. Click on the dropdown list next to “Symbol” and select the “None” option.
  6. Click OK.