Formula Formatting

K

Kimmy

Is it possible, without rounding, for a cell to display it’s contents only if
the value within the cell is a whole number?
 
J

J

'Cell' is excel talk! We say 'Field' in access country.

I recommend you use a query that has as one of its "Fields" be:
Field1Fixed: Iif([Field1]=Int([Field1]),[Field1],"")

or if you are actually asking if you can filter in only the rows that
have whole numbers then under query CRITERIA you want:
=Int([Field1])

Best of luck,
~J
 
Top