Formulas and functions > Functions from A to Z > N (convert value into number)

Syntax:

N(Value)

Description:

This converts a value into a number.

The specified value must be a number, a date value or a logical value, otherwise N returns zero.

Note:

This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including Calculate) automatically convert values into numbers if necessary.

Example:

N("Text") returns 0

N("42") returns 0

N(42) returns 42

N(TRUE) returns 1

If A1 contains the date 09/25/2014, the following applies:

N(A1) returns 41907 (the serial number of that date)