wksNumericType Values

Enumeration

Value

Description

wksTypeGeneral

0

displays numbers as precisely as possible given the cell width

wksTypeFixed

1

displays numbers with a fixed number of decimal digits

wksTypeExponential

2

displays exponential numbers

wksTypeCurrency

3

displays numbers with a currency symbol

wksTypeDateTime

4

displays dates and times instead of numeric equivalents

wksTypePercent

5

displays numeric values (such as 0.13) as percentages with a percent symbol suffix (13%)