Toggle Help Topics Menu >

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 ¥.