Pivot date grouping

[sue]

I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please

 

[Debra Dalgleish]

When you get the data from the query, the dates may be imported as text,
which would prevent them from being grouped. There are instructions here
for converting the text dates to real dates:

http://www.contextures.com/xlDataEntry03.html

 

[CyberTaz]

Suggestions will vary depending on version. Please provide more info. |:>)

 

[sue]

Hi

I am working with office 2003 professional- The date is formatted as
*14/03/2001 however the pivot table does not seem to reconize this as a date
-

 

[sue]

Hi thankyou,
the date is formatted as *14/03/2001, it appears to be reconized as a date
for everything but the pivot table.