I need to create a PivotTable from an imported woksheet. I am having
two problems.

My Pivot Table is [Rows] Part Number [Columns] Month [Data] Order Qty

The purpose of the pivotTable is to Sum the order qty of said part
across each month. Sounds easy!

Problem 1.
The date field is imported into Excel from Access in the format dd-mmm-
yy i need it in the PivotTable in the format mmm-yy therefore i have
used the Year and Month functions (in spearate columns) to extract
that information and then Concatentate to pull them together in the
column i want. In my macro i have also attempted to format that column
but it doesn't seem to work.

Now when i pull the date into my PivotTable the format is General and
is sorted in alphabetical order not as a date.

Problem 2.
I also import a Order qty field as text, in excel i have attempted to
format it in a macro to number "0" format. When i put this into my
PivotTable it will not SUM the order quantities. It will count them
but when i sum them it returns a value of 0.

Please help! I am a novice with PivotTable's but the actual table is
very basic. I have tried to format the fields in the PivotTable but
nothing changes.