okeyuzosike
Programmer
Please, I need some assistance.
I am importing data from an acces table (file) into Excel spreadsheet. The data type in the access table is "Number"(numeric). When copied from the access file to the excel spreadsheet, some of the numbers converts to date.
In the source file, the underlying data is "7", but in the spreadsheet, it converts to "1/7/1900".
What is the cause of this and how can I fix it?
Note: this applies to some of the data not all. Some are numeric and some are some weired date. As you can see, the year is not even "2007" but "1900".
Thanks.
Okey.
I am importing data from an acces table (file) into Excel spreadsheet. The data type in the access table is "Number"(numeric). When copied from the access file to the excel spreadsheet, some of the numbers converts to date.
In the source file, the underlying data is "7", but in the spreadsheet, it converts to "1/7/1900".
What is the cause of this and how can I fix it?
Note: this applies to some of the data not all. Some are numeric and some are some weired date. As you can see, the year is not even "2007" but "1900".
Thanks.
Okey.