Cell formatting from Access

  • Thread starter Thread starter Rusty Ashbaugh
  • Start date Start date
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
 
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
 
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
 
Back
Top