NumericType Property

The NumericType property returns or sets the numeric format type in the worksheet. A null is returned if all the cells in a the range do not have the same numeric format type. Returns a variant.

Syntax

object.NumericType

object.NumericType = Type

Example 1

This example demonstrates how to return the numeric format of a cell.

Debug.Print WksCellFormat. NumericType

Example 2

This example demonstrates how to display numbers as precisely as possible give the cell width.

WksCellFormat.NumericType = wksTypeGeneral

Used by: WksCellFormat object