Convert Numbers Stored As Text When Using A Formula

less than 1 minute read

There are a few ways to convert Numbers stored as Text using Formula. You can use:

  • =VALUE() or =NUMBERVALUE() for floating point Numbers.
  • =INT() if you just have whole Numbers
  • =T() to retain formatting.

If you have a Number stored as Text in Cell A1 use any of the following:

'// converts a Number stored as Text into a Number
=VALUE(A1)

'// whole Number
=INT(A1)

' // Converts text to a number, in a locale-independent way (new for Excel 2013)
=NUMBERVALUE(A1)

'// if you have a Number stored as Text like 1,200 this will retain its comma formatting
=T(A1)