STYLENUMBERFORMAT

This function returns the format of a number style.

Syntax

=STYLENUMBERFORMAT("style_name")

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.

Example

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

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