sawgee2001
New Member
- Joined
- Nov 26, 2002
- Messages
- 24
When I export a date field from my payroll database into Excel, Excel does not recognize the data as a "date". For example, January 15, 1976 would be entered into the our payroll software as 01/15/1976, and when this field is exported into Excel, it appears as 01/15/1976. However, when I try to sort on the column of exported data to create a list based on seniority, it sorts based on the data from the left, not by the year. I've checked the regional settings, and it is set as "mm/dd/yyyy". I've tried to format the column, using a custom date format, but this does not seem to change anything. Any ideas out there?
This message was edited by sawgee2001 on 2002-11-27 00:06
This message was edited by sawgee2001 on 2002-11-27 00:06