Data import from Access file to Excel spreadsheet conversts to date. 2

[okeyuzosike]

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.

 

[PHV]

Change the format of the Cell back to standard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

This may explain SOME of the dilemma.

faq68-5827

Skip,

_[red][/red]