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

N(value)

 
 Returns the value converted to a number.

 valueThe value you want converted to a number.

 REMARKS
 
  		• This is one of few functions that does not require any arguments.
     
  		• It is not generally necessary to use this function in a formula, because Excel automatically converts values as necessary. ??
     
  		• This function is a great way to include a text description into a cell containing a formula, without it affecting the formula.
     
  		• This function is provided for compatibility with other spreadsheet programs.

     EXAMPLES
     
     A
    1=N(2) = 2
    2=N("2") = 0
    3=N(0.12) = 0.12
    4=N("01/07/1987") = 0
    5=N("some text ") = 0
    6=N(10/0) = #DIV/0!
    		 
     Functions - N | Index - N | Office Online 

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