# N

### Definition of N

Returns the argument provided as a number.

`N(A2)`

`N(4)`

### Syntax

`N(value)`

• `value` - The argument to be converted to 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 December 30, 1899.

1. Negative values are interpreted as days before this date, and fractional values indicate 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 Spreadsheet automatically converts between most formats appropriately. It is provided primarily for compatibility with formulas used in other spreadsheet packages.

`TO_DATE`: Converts a provided number to a date.

`T`: Returns string arguments as text.

### Excellentable will generate the outcome when hitting enter.

A
B
C
1
State
 Population
Total area in mi2
Land area in mi2
Water area in mi2
2
Alabama
4833722
52,420 (135,767)
3
735132
665,384 (1,723,337)
4
Arizona
6626624
113,990 (295,233)
5
Arkansas
2959373
53,179 (137,733)
6
California
38332521
163,695 (423,968)
7
5268367
104,094 (269,602)
8
Connecticut
3596080
5,543 (14,356)
9
Delaware
925749
2,489 (6,446)
10
Florida
19552860
65,758 (170,312)
11
Georgia
9992167
59,425 (153,910)
12
Hawaii
1404054
10,932 (28,314)
13
Idaho
1612136
83,569 (216,443)
D
E
F
1
House seat(s)
2
50,645 (131,170)
1,775 (4,597)
7
3
570,641 (1,477,950)
94,743 (245,383)
1
4
113,594 (294,207)
396 (1,026)
9
5
52,035 (134,770)
1,143 (2,960)
4
6
155,779 (403,466)
7,916 (20,502)
53
7
103,642 (268,432)
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
540 (1,399)
1
10
53,625 (138,888)
12,133 (31,424)
27
11
57,513 (148,958)
1,912 (4,950)
14
12
6,423 (16,635)
4,509 (11,678)
2
13
82,643 (214,044)
926 (2,398)
2
G
1
2
TRUE
3
TRUE
4
TRUE
5
FALSE
6
TRUE
7
FALSE
8
TRUE
9
FALSE
10
TRUE
11
FALSE
12
TRUE
13
FALSE

JavaScript errors detected