Cell formatting from Access

R

Rusty Ashbaugh

When I export an Access report to Excel, one of the fields, which is a time
field, e.g., 15:10.9 in Access becomes "0.63205" in Excel. Some kind of
decimal formatted cell. How can I export to Excel without this format
change?
Thanks,
Rusty
 
B

Bernie Deitrick

Rusty,

After the import is done, simply format those cells as time, with the custom
mm:ss.s format - though you will have to first divide all the values by 60.
The 15 minutes and 10 seconds from Access is becoming 15 hours and 10
minutes, since Excel requires the entry to be 0:15:10.9 to treat the value
as minutes and seconds.

HTH,
Bernie
MS Excel MVP
 
R

Rusty Ashbaugh

Bernie,

Thanks for the insight. That's exactly what Excel is doing to my Access
fields. Since I can't have the times rounded off at all, I'm reconfiguring
Access to export in the hh:mm:ss.s format... That works! (Although now if
Access exports hh:mm:ss.0, i.e., ending in zero I get a decimal cell again.
Nevertheless, you have definitely shown me what is happening, so I can
figure out how to fix it. Thank you very much.
Rusty
 
Top