Decimal Place Problem via Export

  • Thread starter Thread starter lalexander
  • Start date Start date
L

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.
 
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
 
When you export numbers to Excel, they automatically get the standard
numeric format set in the Regional Settings on your computer.

(david)
 
Back
Top