Drop decimals and zeros when not needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to hide decimals and zeros when they're not needed. For instance,
if I type 3 I'd like to show as 3 instead of 3.00, and if I type 3.5 I'd like
it to show 3.5 instead of 3.50. I can't find how to do this but surely it can
be done.
Thanks.
 
In that case, you need to open the table in design view.
Select the field.
In the lower pane of table design, set the Field Size to:
Double

The Integer types cannot hold fractional values.
 
No. The Double handles up to 15 places of precision.

If you always want 2 places to be shown, set the Format property to Standard
(for Fixed) and set the Decimal Places to 2.

But if you want the format to be flexible (i.e. whatever is appropriate for
the number), use General Number.
 
Back
Top