From Standard Numeric Format Strings
The number is converted to a string of
the form “-d,ddd,ddd.ddd…”, where ‘-‘
indicates a negative number symbol if
required, ‘d’ indicates a digit (0-9),
‘,’ indicates a thousand separator
between number groups, and ‘.’
indicates a decimal point symbol.
It would seem that N
will include thousands separators, whereas 0.00
will not.
See also Custom Numeric Format Strings