I have a spreadsheet with a single column, but many rows of dollar values. The problem is that the "$" is manually typed in the cell and I would like to use the numeric values in the cell. Is there a macro I could run to remove the "$" ? It seems simple to me, but I can't think of a way to do it. Any help would be greatly appreciated. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remove text from cell in Excel
- Thread starter Roblin
- Start date
When you select one of the cells containing the $, does the $ show in the Formula Bar?
IF YES,
Select all the cells from which you want to delete the $ then do a Find and Replace (find $, replace with [leave blank])
IF NO,
Simply change your cell format to Number
- Status
Similar threads
- Locked
- Question