NumericType Property

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

Syntax

object.NumericType

object.NumericType = Type

Parameter	Type	Description
Type	wksNumericType	required

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