Convert a value to a number

Sponsored Link


Convert a value to a number

Return value 

A number or error code


=N (value)


  • value - The value to convert to a number.

Usage notes 

Use the N function to convert value to a number. Values are converted according the the following table:

Input valueReturn value
Any numberSame number
A recognized dateA date in Excel serial number format
An error code (#VALUE, #N/A, etc)Same error code
Other values0

In most cases, using the N function is unnecessary, because Excel automatically converts values when needed.

The N function is provided for compatibility with other spreadsheet programs.

Note: you should know there is a tricky use of N() that allows you to use it as a way to leave in-cell comments. The technique:  add a plus sign at the end of your formula with a comment as text in quotes inside the N() function like so:

=SUM(A1:A10) + N("This is my comment about this SUM function")

When you click on that cell, you'll see both the formula and the comment in the formula bar. The N() function has no impact on the result of the function. In fact, you can add more than one N() function to a formula to annotate other functions, constants, or both.

Sponsored Link

0 votes. 0 / 5