pivot table formatting

[Dal]

Hi all,

I have alot of pivot tables in my workbook and was wandering if there is a
way that all the data inside the pivot table automatically aligns itself left
without having to manually select this. At the moment the data is all over
the place.

Thanks, Dal