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 predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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