Solved problem getting dates to group together in pivot table?

July 10, 2014 at 08:40:15
Specs: Windows 7
Will not let me group saying that all the data is not formatted as dates and it is, don't understand?

See More: problem getting dates to group together in pivot table?

Report •

#1
July 10, 2014 at 09:05:29
✔ Best Answer
It may LOOK like a date, but it is probably TEXT.

Try this with one of the offending Dates:

Format the cell as Number, if the cell displays as a Date,
then the date is really TEXT,
if it displays a five digit number like: 41830
then it is a Date that Excel understands.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question