NFMTTONEUTRAL
This function changes a number format from the current locale to a neutral locale.
Syntax
=NFMTTONEUTRAL("current_number_format")
Example
In this example the current culture is English (neutral).
Cell A3 contains this number format #,##0
.
Cell B3 contains this formula: =NFMTTONEUTRAL(A3)
.
The formula returns #.##0
.
Example
In this example the current culture is Czech (non-neutral).
Cell A3 contains this non-neutral number format # ##0
.
Cell B3 contains this formula: =NFMTTONEUTRAL(A3)
.
The formula returns #,##0
.