N in Google Sheets: Numeric Conversion and Date Serials
Use Google Sheets N on Booleans, text and dates, with the documented 1899 epoch, time fractions and explicit indicator columns.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: N preserves a number, turns TRUE into 1 and FALSE into 0, and maps ordinary text to zero. =N("42") therefore gives 0, not 42. Use a suitable parser when the aim is to convert numeric text into a quantity.
Availability and version history
- Introduced: first introduction date is not established by the official history reviewed; no desktop release number is inferred.
- Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
- Checked: October 14, 2026; official N reference. Documentation and independent models, with no native Google Sheets execution or wider client certification.
Syntax and documented scope
=N(value)
The required value can come from a cell or an expression. Google’s dedicated reference describes date/time serials using December 30, 1899 as the day-count base, with fractions representing time since midnight. It also explains that the input cell’s display formatting is not carried through as a formatting instruction for the result.
The source uses broad catch-all wording for other values without an explicit error-value control. This guide does not infer native error propagation or error-to-zero behavior from that sentence; error inputs remain a separate test case.
Example 1: inspect ordinary scalar conversions
Enter these values in A2:A7, then fill =N(A2) down column B.
| Cell | Entry | Expected result |
|---|---|---|
| A2 | number 42 |
42 |
| A3 | ="42" |
0 |
| A4 | =TRUE() |
1 |
| A5 | =FALSE() |
0 |
| A6 | ="Pending" |
0 |
| A7 | ="" |
0 |
For the simple ASCII digits in A3, =VALUE(A3) gives 42, while N gives zero. The same visible characters can therefore lead to very different outcomes depending on the function selected.
If A3 is an identifier rather than a measurement, parsing it may be inappropriate even when possible. N is a defined conversion function, not a general import repair operation.
Example 2: turn a condition into an indicator
Put numeric measurements 6, 11, 10, 4, 13 in D2:D6. In E2 use:
=N(D2>=10)
Fill down. Expected indicators are 0,1,1,0,1, totaling 3 qualifying observations. If F2:F6 contain weights 2,4,3,5,7, the row products =E2*F2 produce 0,4,3,0,7, totaling 14.
The first total counts qualifying rows; the second sums their weights. N converts an already formed Boolean condition. It does not validate that an imported comparison operand was numeric, so add ISNUMBER checks if the measurement field can contain other types.
Example 3: show a date and a time as numbers
Put =DATE(2026,10,14) in H2 and =TIME(6,0,0) in H3. Format the N output cells as ordinary numbers when inspecting them.
=N(H2)
=N(H3)
=N(H2+H3)
Expected numeric results are 46309, 0.25 and 46309.25. Six hours is one quarter of a day. A time of 18:00 has fraction 0.75, and the difference between 18:00 and 06:00 is 0.5 day, or 12 hours.
These examples follow Google’s documented epoch, rather than importing a workbook-specific desktop date-system setting. A date-looking text string still needs its own parsing; N does not promise to parse arbitrary date text according to your intended locale.
Example 4: add a literal note without changing a numeric total
Put 14, 21, 35 in K2:K4. This formula has expected numeric result 70:
=SUM(K2:K4)+N("Approved input block K2:K4")
The literal string contributes zero. Its wording is merely an annotation: it does not prove that any real approval or audit happened. Keep actual review evidence elsewhere.
Substituting N(TRUE()) would instead add one and produce 71. Using an arbitrary cell as the annotation input could likewise change the calculation if that cell becomes numeric. This pattern is appropriate only when its deliberate numeric-zero behavior is understood.
Formatting, errors and related functions
Applying a currency format to A2 does not make N a currency converter. The returned numeric value is still 42 in the first control; format the output cell separately for presentation.
Use VALUE for suitable numeric strings and ISNUMBER to inspect without converting. Error inputs, imported special values and a complete blank/null conversion matrix are held rather than presumed identical to another spreadsheet’s N implementation.
References and verification
Examples use fictional inputs, English function names and comma argument separators. Expected outputs are independently modeled from the cited rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.