Hi!

I am using vba to create pivot table via ADO using data from access db
Here is my data field


objMyPivotTable.PivotFields("Salary").Orientation
xlDataField


If I would like my data field has the format of "#, ##0" - that mean
no decimal, I am not sure how should I do that?

Please advise.

Aijun

--
Ai_Jun_Zhan
-----------------------------------------------------------------------
Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php...fo&userid=2547
View this thread: http://www.excelforum.com/showthread.php?threadid=47007