Values are converted as shown below.
Numeric values and errors are unaffected.
The N function is provided for compatibility with other spreadsheet programs.
In most cases, using the N function is unnecessary, because Excel automatically converts values when needed.
you’ve got the option to use the T function to remove values that are not text.
