You *are* aware, that the return of the FIXED() function is *text*, and
*not* a number.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Mustang" wrote in message
...
That worked! Thanks!!!!!

"Gary''s Student" wrote:

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