Hi All,
My head office has recently redeveloped our website and the back end is set up differently. I used to cut and paste a list of events, to create a roster for my staff. Do a little cosmetic eidting and reorganising and then email to the staff.
With the new back end of our website, when I cut and past the list of events, the date column is recognised by excel as text.
Monday, 3 September 2012 19:00
When I try to do a 'sort' it on a list of 80 events, it puts all of the Fridays first and Wednesdays last. I have selected the column and changed it to date format, but this doesn't help. I have also tried using the 'text to columns' function, but that doesnt seem to work either.
All I need is the date and time, the day I can delete or add later (prefer to keep it in a different cell - but fine with it all being in one cell)
Any help would be greatly appreciated.
Cheers
Dee
Bookmarks