FORMAT.NUMBER

Macro Sheets Only

Equivalent to choosing the Number tab in the Format Cells dialog box, which appears when you choose Cells from the Format menu. Formats numbers, dates, and times in the selected cells, data labels, and axis labels on charts. Use FORMAT.NUMBER to apply built-in formats or to create and apply custom formats.

Syntax

FORMAT.NUMBER(format_text)
FORMAT.NUMBER?(format_text)

Format_text is a format string, such as "#, ##0.00", specifying which format to apply to the selection.

Related Functions

DELETE.FORMAT Deletes the specified custom number format

FONT.PROPERTIES Applies a font to the selection

FORMAT.TEXT Formats a sheet text box or a chart text item

List of Command-Equivalent Functions