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