If you click on the cell you can see a small leading apostrophe sign.There would be a green triangle on the top left corner of the cell.Excel always aligns text to the left and numbers to the right within cells The cell would be aligned to the left, instead of right.You can easily tell if this was the case by checking for tell-tale signs: Some people like to add the dollar symbol by converting the cell to text. If the above method did not work, it might be because the dollar symbol was not added by formatting. This should remove the dollar symbol from all the selected cells. Click on the dropdown list next to “ Symbol” and select the “ None” option.Under the Category list, select the ‘Currency’ option.
Suppose you have a dataset as the one given below, and you want to remove all dollar signs from column B. If the dollar sign was added due to a currency format setting, then you can use this method to remove it. Removing Dollar Sign by Using the Format Cells Dialog Box
