If you are not sure about how the dollar sign was added, there’s a fool-proof way to extract just the value of the cells. This is by using the VALUE() function.
- In a new column, type =VALUE() and within the brackets, put a reference to the first cell from which you want the dollar sign removed
- Press the Return key.
- You will find only the value of the cell in question, sans any formatting that had been applied. You can copy this formula to the rest of the cells in the column by double-clicking the fill handle.