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
Google Sheets: Format > Number > Automatic
@hippy started
London Fixed Gear and Single-Speed is a community of fixed gear and single-speed cyclists.
hippy
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