You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
-
=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.
aggi
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