alan,
What Bob said is correct. You can change the way Excel formats
the date to however you want by right-clicking on the cells and
selecting
Format Cells..., then clicking on either Date, Time,
or Custom, and changing the format that way, however this will have no
bearing on how Excel sorts the columns. The values are stored in
Universal Time format.
Doug M
Applications Engineer
National Instruments
For those unfamiliar with NBC's The Office, my icon is NOT a picture of me 🙂