Convert Text to Number
This tool will find all the cells in the selected range that have numbers stored as text and converts them to numbers, retaining the original formatting where possible.
Accepted Formats
- Integers
- Decimals
- Percentages (%)
- Negative numbers: minus "-5.00" and accounting "(5.00)" formats.
- Currency symbols: $, £, €, and ¥.