NumericType Property

The NumericType property returns or sets the numeric format type. 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, general, fixed, exponential, or currency

 

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 given the cell width.

WksCellFormat.NumericType = wksTypeGeneral

 

Used by: WksCellFormat object