Number Format Types

[#1]

Hi

Can someone please help me, I am trying to dynamically set the number format of an expression in a chart

Similar to:

expItem.Label.v = ActiveDocument.fields(ViewMode&"PivotEx").GetPossibleValues.Item(0).Text               expItem.NumAdjust = 2    'right align               expItem.TextAdjust = 2                     expItem.LabelAdjust = 2    'right align               set expItem = p.Expressions.Item(i).Item(0).Data.ExpressionVisual.NumberPresentation               ' Set the number format               select case ActiveDocument.fields(ViewMode&"PivotType").GetPossibleValues.Item(0).Text                     case "Decimal"                               expItem.Dec = "."                               expItem.Fmt = "#,##0.00"                               expItem.nDec = 2                               expItem.Thou = ","                               expItem.Type = 11     'fixed decimal                               expItem.UseThou = 1                     case "Integer"                               expItem.Fmt = "#,##0"                               expItem.Thou = ","                               expItem.Type = 10     'integer                               expItem.UseThou = 1

I was wondering if how to find a list of values for expItem.Type, I coudn't find this info from the API guide.

I actually need to set the type to interval

Thanks

Andy