Pacifica09
New Member
- Joined
- Jan 19, 2009
- Messages
- 2
I have a csv file (from fox pro db) which I converted to Excel 2007. This xls file contains the fields: EmployeeID, EmployeeName, Date, Day, Time, etc....(Looks great in PDF) HOWEVER, in xls, the date, time and day come out wrong. How can I convert the 10-digit number to normal date format?
Egs: of a 10-digit number I have in the first 3 cells are: 3441076560; 3441076261; 3441077042 and so on.
I'm wondering if the time is also included in this 10-digit serial number?
Please help.
Egs: of a 10-digit number I have in the first 3 cells are: 3441076560; 3441076261; 3441077042 and so on.
I'm wondering if the time is also included in this 10-digit serial number?
Please help.