VALUE Function

Written by kazamraza no comments
Classified in : Excel Formulas, Text Functions Tags : none

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 value, Error values and Boolean data are center aligned

Normally VALUE function is used with other functions.


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