TEXT
This function takes a numeric value that is formatted in the current culture. It returns a text representation of that value that is also formatted in the current culture.
Syntax
=TEXT(value, "format_text")
Example
In this example the current culture is English (neutral).
Cell B14 contains this numeric value: 12345.67.
Cell A14 contains this neutral number format: #,##0.
Cell C14 contains this formula: =TEXT(B14,A14).
The formula returns this text representation of the value: 12,346.
Example
In this example the current culture is Czech (non-neutral).
Cell B14 contains this numeric value: 12345,67.
Cell A14 contains this non-neutral number format: # ##0.
Cell C14 contains this formula: =TEXT(B14,A14).
The formula returns this text representation of the value:12 346.