Round when exporting to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nFaux - 15 Aug 2006 19:08 GMT

I get the result in Access to round fine, until it is output to excel.

For example: actual result in access is .5, queried as 1, but when I output
it to excel, it shows .5, not the desired 1.

I used Round([Expression],0) in access to get the 1 result in the query. So
I am thinking this is an excel formating issue?

Signature

Neil

Reply to this Message

lisa b. - 15 Aug 2006 19:12 GMT

I'm not the expert but in excel, you would change it to number format with no
decimals.

Lisa

> I get the result in Access to round fine, until it is output to excel.
>
[quoted text clipped - 3 lines]
> I used Round([Expression],0) in access to get the 1 result in the query. So
> I am thinking this is an excel formating issue?

Reply to this Message