N

Returns the argument provided as a number.

Sample usage

N(A2)

N(4)

Syntax

N(value)

  • value – The argument to be converted into a number.

    • If value is TRUE, N returns 1.

    • If value is a number, the number is returned.

    • If value is a date or time, N returns a generated serial number, based on the number of days since 30 December 1899.

      1. Negative values are interpreted as days before this date, and fractional values indicate the time of day past midnight.
    • If value is FALSE or any value not listed above, N returns 0.

Notes

  • When using N on numeric values in other cells, formatting (into currencies, scientific notation, etc.) is lost. To specify formatting on the return value of N, simply apply the format desired to the cell containing the formula.

  • This function is, in fact, rarely necessary, as Google Sheets automatically converts between most formats appropriately. It is provided primarily for compatibility with formulas used in other spreadsheet packages.

See also

TO_DATE: Converts a provided number into a date.

T: Returns string arguments as text.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

11794590902506549461
true
Search Help Centre
true
true
true
true
true
35
Search
Clear search
Close search
Main menu
false
false
false