In an unused cell enter .95 Copy that cell and paste/special/multiply onto
the values you are trying to change.
--
Gary''s Student - gsnu200794


"capxc" wrote:

Hi,
I have column D with 24000 rows ( D1 to D24000 ).
I need to reduce all the values already entered in that column by 5%.
I have 07 Microsoft Office and I tried couple formulas but it did not work.
Can anyone tell me how to do it the right way?
--
capxc