You are reading a single comment by @Dammit and its replies.
Click here to read the full conversation.
-
Google Sheets: Format > Number > Automatic
-
=VALUE(SUBSTITUTE(SUBSTITUTE(A1,"$",""),",",""))Where A1 is your cell with the badly formatted number
Chances are it isn't actually reformatting it as a number (if you can't sum them, etc then it isn't a number) and is still text. Either use the above or highlight the cells and use text to columns.
-
Ctrl+F then choose replace $ with blank.
hippy
aggi
coventry_eagle
@Dammit
If a cell contains the following value, but is formatted as text, how do I remove the currency sign and comma once I've changed it to being formatted as currency, without having to go into every cell and delete those manually?
$60,000