N Function

Converts a value to a number.

Category

Information

Available in

All versions, Microsoft 365

Returns

A number

Want to practice N in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

N turns a value into a number: numbers stay the same, dates become their serial number, TRUE becomes 1, and FALSE, text and blanks become 0. Errors pass through unchanged.

Its best-known use is a quirky one — adding a note inside a formula, because N of any text is 0.

Syntax

=N(value) Explain

Arguments

ArgumentRequired?What it does
valueYesThe value to convert.

Examples

Example 1 — What N does to different values

Text — even text that looks like a number — becomes 0.

B2fx=N(A2)
AB
1ValueN
2125125
33/15/202646096
4TRUE1
5Pending0
60
=N(A2) Explain

Example 2 — A note inside a formula

N("…") adds zero, so the result doesn't change but the next person reading the formula sees why.

=SUM(B2:B13)+N("Excludes the March refund — see Notes tab") Explain

Common mistakes

  • "42" becomes 0, not 42. N doesn't convert text numbers. Use VALUE or --A2 for that.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.