DELETE.FORMAT macro

Equivalent to deleting the specified format in the Number tab in the Format Cells dialog box, which appears when you click the Cells command on the Format menu, or in the Number tab for selected chart objects. Deletes a specified built-in or custom number format.

Syntax

DELETE.FORMAT(format_text)

Format_text    is the format given as a text string, for example, "000-00-0000".

Remarks

When you delete a custom number format, all numbers formatted with that number format are formatted with the General format.

Related Functions

FORMAT.NUMBER   Applies a number format to the selection

GET.CELL   Returns information about the specified cell

Return to index