I am working with one of our engineers that wants to have a cell with a
formula show only whole numbers. He does not want rounding, but to be able
to code a statement that will error out if the result is a deciaml or
fraction. I looked at the Data - validation properties, but it only works
with an entered number not a formula. Is there a simple way to do it without
having to write a program in vb?