Numbers exported to Excel

B

bigitch

When I export various numeric fields to Excel, they show as 4 or 5 decimals
of detail, when they were just integers in Access? Any idea why?
 
A

Arvin Meyer [MVP]

bigitch said:
When I export various numeric fields to Excel, they show as 4 or 5 decimals
of detail, when they were just integers in Access? Any idea why?
Click to expand...

More of an Excel question, but I can answer this one. Open any workbook and
go to Tools ... Options. Now click on the Edit tab and check the checkbox
with the label Fixed Decimal, and set the Places to 0. Click OK. Your'e
done!
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top