Decimal Place Problem via Export

[lalexander]

When converting a report into an excel file for email , it somehow shows the
2 decimal places
on the excel spreadsheet - even though I had indicated within the report
that the

Format=Standard
Decimal=0

I eventually wanted to create a format like 200,000
but it's giving me 200,000.00

I can manually strip the 2 decimal places in excell but do not want the user
to play with this functionality.

Could someone assist.

 

[Ed Robichaud]

Try using the Format() function. Iin your control source of the field on
your report, use something like: "=Format([myNumber],######)
See Access help file for Format() parameters and examples.
-Ed

 

[david epsom dot com dot au]

When you export numbers to Excel, they automatically get the standard
numeric format set in the Regional Settings on your computer.

(david)