Hi

I get the telephone numbers, using the sample data you posted.
I guess your numbers are Text and not numbers, that would give 0's
throughout the PT.

Format your Tel No column as FormatCellsNumberCustom 00000000000
Enter a 1 into a blank cell on your sheet. Copy that cell.
Mark your range of numbers and Paste SpecialMultiply. This will turn them
to numerics.
Refresh the PT and you should see the result as required.

Regards

Roger Govier


philawde wrote:
hey ive tried both of these methods... using the pivot table jst meant i
had the right columns and headings but for the numbers i jst got loads
of 0's in the correct boxes but not the numbers for that id. and weneva
i ty and use that code it keeps crashing! ne help?? email me at
i can show file if needs b