Fantastic...........a well organised forum, I got what I want, its working fine regardless one issue, i've pivot filter with date wise display, using this the list box shows date format as 'mm-dd-yyyy" , On my work sheet & Pivot filter s it is dd-mm-yyyy, please how to correct the date format in...