You might also be interested in
Replies (5)
Please login or register to join the discussion.
Sage dates aren't dates!
When Sage Line 50 exports dates onto Excel, they actually come over as text. Try sorting by date, and you will see that they don't actually sort into date order.
You first have to turn the dates into proper dates. The easiest way is to highlight the Date column, then Data - Text to Columns - in Step 3 tick the DATE button. Finish.
Excel will now modify the column into real dates.
To check that a date really is a date in Excel, highlight the column, then Format - Cells - Number. If it changes to a number like 39000 or thereabouts, it's a date. If it still looks like a date - it isn't one!
Grouping in Pivot Tables
I've decided to try and learn more about Pivot Tables and am working through David Carter's Tips. With Tip 2 i've got the grouping to work fine with the demo data but when I try the same excercise on my actual data from Sage Line 50, and Group on Date I get the message "cannot group that selection". Any ideas what I am doing wrong?
Thanks
Month Order
Hi
Pretty new to Pivot Tables so excus emy ignorance.
I used the grouping function to total by month but it then runs by calendar year; Jan-Dec. I want it to run by financial year, July to June. Looking ofrward to your answers - great site.
no problem
Hi Graeme
If you take another look at the Grouping box you will see at the top a "Starting at" field and an "Ending at" field.
In "Starting at" type in July 1st 2004 and in "Ending at" type in June 30 2005. Then below that make sure you highlight both "Month" and "Year". This should do it. David