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
Ctrl+F then choose replace $ with blank.
@coventry_eagle started
London Fixed Gear and Single-Speed is a community of fixed gear and single-speed cyclists.
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