Excel \ Access Time issues

M

Marcus

Please can someone help me.

When I import data into an excel spreadsheet from MS
Access the date format corrupts to date format i.e
01/09/1900.

I cannot get time format back correct is there anyway of
converting time back to 24 hr clock within excel.

The Time format in Access is hh:mm:ss (I think) when i try
to convert this to excel it returns a date everytime.

Marcus
 
Top