Decimal Places not working

[Guest]

Hi,

I have a report that has some numbers and calculations on it.

The original table is a linked table from excel.
The calculations of the affected fields in excel are:
=77+K120-20*(LOG(OffAir!P120))
=S121-T121-U121
=20*LOG(39.5/E122)
=V117+W117-X117+Y117
=Z115+AA115

These are the fields that show up in my access report as many decimals. I
have tried changing all formatting to 1 decimal but it still shows up with
about 6 or more.

Is there a way I can fix this so that my report is only showing the
calculations with 1 decimal? They show up correctly in excel and in my
access table but not on the report.

 

[Duane Hookom]

Are the fields left or right aligned when viewed in datasheet? Did you set
the format property to "Standard"?

 

[Guest]

They are right aligned. I couldn't find '"Standard" format but I changed it
to "Fixed" and that works fine.

Thanks