/ have a column of cells which has date and time in one cell e.g.
07/11/2009 08:07:22 (I have attached a spreadsheet with some examples)
I can get the information extracted if i use: =TEXT(A10,"HH:mm") for the time and change HH:mm to MMM-DD for the date
However, when I run a Pivot it sorts the date alphabetically rather than by date.
Anyone know how I can get around this?
Bookmarks