View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nick Lyttle Nick Lyttle is offline
external usenet poster
 
Posts: 4
Default Pivot Date format

I've recently loaded Office 2003 onto my laptop and am trying to run a pivot
table to review the last date of customer visit from a data source, the
format of the date using Max of field choice delivers total colum results
that are identical, all display 00/01/1900. I have searched and cannot find
any setting that appears wrong but I am sure there is a simple setting
somewhere I have wrong. The Cell format both in source data and in pivot
table column are set to date (non asterix) and other field such as count of
date seems fine.

Any help please, greatly appreciated.