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)

Tags: text-strings

Categories: formulas

Updated: October 11, 2018

Twitter Facebook LinkedIn

1 minute read

Here’s the simple steps to highlight the row and column of the selected cell which can be extremely useful when navigating large sets of data. Here’s a littl…

less than 1 minute read

How it Works Using SEARCH and ISNUMBER When you need to check if a cell contains specific text (or string) we need to combing the SEARCH and ISNUMBER functio…

less than 1 minute read

So you have a 0% value on one of your data labels and want to hide it?

1 minute read

Download the example workbook here: calculate-time-between-dates.xlsx

Leave a Comment