View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Seede Seede is offline
external usenet poster
 
Posts: 3
Default formatting date for pivot table

hello
the data in my spreadsheet is with datetime. when i create a pivot table, it
creats multiple rows for data with same date.
when i tried to change the format, it did not help
how can i create a pivot table that does not create multiple rows for data
with sme date when my souce excel data is in datetime.