Numbers exported to Excel

[Guest]

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?

 

[Arvin Meyer [MVP]]

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?

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