![excel symbols locking excel symbols locking](https://www.avantixlearning.ca/wp-content/uploads/2015/09/data-key-571156_640.png)
In a new column, type = RIGHT(B2,LEN(B2)-1).If any of the above signs suggest that the cell is actually text, here’s how you can remove the dollar sign: If not, it means your cell does not contain text. If you get the result as TRUE, it means your cell contains the text. You can also double check by typing the formula =istext in an empty cell and passing the reference to your cell.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.
![excel symbols locking excel symbols locking](https://cdn.wallstreetmojo.com/wp-content/uploads/2019/05/Dollar-in-Excel-Example.png)
This should remove the dollar symbol from all the selected cells.
![excel symbols locking excel symbols locking](https://static.javatpoint.com/ms/excel/images/how-to-unlock-scroll-lock-in-excel-7.png)
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 Removing Dollar Sign by Using the VALUE Function.Removing Dollar Sign by using Find and Replace.Removing Dollar Sign by Using a Formula.Removing Dollar Sign by Using the Format Cells Dialog Box.