STYLENUMBERFORMAT

Returns the current format of a named number style format. This can be used to simplify the use of the TEXT function, which takes a number format as its second argument and which requires number formats appropriate to the current regional settings.

Syntax

=STYLENUMBERFORMAT("name_of_style")

Example

Create a style and specify a number format.
See Formatting cells.
Specify a numerical value in a cell.
In another cell, specify: ="sometext "&TEXT(cell_reference,STYLENUMBERFORMAT("name_of_style"))

The formula returns "sometext" followed by the numerical value, formatted according to the named style.