Round when exporting to excel

[Guest]

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?

 

[Guest]

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

Lisa