Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > VALUE

 

VALUE(text)

 
 Returns the text string that represents a number to a number.

 textThe text string that represents a number.

 REMARKS
 
  • Text can be in any of the constant number, date, or time formats recognized by Microsoft Excel. If text is not in one of these formats, then #VALUE! is returned.
     
  • The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
     
  • This function is provided for compatibility with other spreadsheet programs.
     
  • You do not generally need to use this function because Microsoft Excel automatically converts text to numbers as necessary.

     EXAMPLES
     
     A
    1=VALUE("1,000") = 1000
    2=VALUE("23") = 23
    3=VALUE("16:48:00")-VALUE("12:00:00") = 4:48:00 AM
     

     Functions - V | Index - V | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top