N
Returns a value converted to a number.
InformationInformation & Auditing
What it does
Converts value to a number (dates to serials, TRUE to 1, text to 0).
Syntax
N(value)
Arguments
value(value) — Value to convert.
Examples
Convert to Number
Convert date to serial.
FORMULA
=N(A2)
RESULT
44927
SAMPLE DATA
| A | |
|---|---|
| 1 | Date |
| 2 | 2023-01-01 |