You are correct. It is much easier to fix a formula and copy it than to
re-type piles of numbers.

Say you have 123.456 in A1 and your formula looks like

=A1+.......

replace A1 with FIXED(A1,0) and copy it anywhre you want.
--
Gary''s Student


"Mustang" wrote:

I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?

Thanks,
Mustang