I have 2 columns: Date and DayName Entered date 08/01/2009 in Date column and dragged down to fill the column with consecutive dates. Entered Thursday in DayName and dragged down. Previously, it automatically put Friday in the next row and then consecutive day names. Now it just fills the column with Thursday as if it is just text rather than day name. What am I doing wrong?
The version of Excel giving problems is Student & Teacher edition. It works OK on another version which is Professional. Question now is: can the feature be added to student & teacher edition?
Has anyone got student & teacher version of Office 2007 that they could check please? I've been thinking of upgrading to 2007 and since money is tight, I lean towards the cheap version of 2007 but don't want to lose this Excel feature