VALUE Function

Spread the love

Converts a text string that represents a number to a number.


The VALUE function syntax has the following arguments:
  • Text Required. The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.

There is very little use of VALUE function.

Please note that number are right aligned and text is left aligned. When you find any number which is left aligned, you will see a tool tip green icon in he cell, this tool tip give you an option to convert this text to number. The default alignment of cell data is as follows:

  • Text data is left aligned
  • Number data is right aligned
  • Logical valueError values and Boolean data are center aligned

Normally VALUE function is used with other functions.

Data Formula Result Employee ID Salary
1,000 =VALUE(A2) 1000 1001 50625
1001 – Imran =VLOOKUP(VALUE(LEFT(A3,4)),$D2:$E$3,2,FALSE) 50625 1005 123000
1005 – Usman =VLOOKUP(VALUE(LEFT(A4,4)),$D2:$E$3,2,FALSE) 123000