1) In E1 type =D1*(1-5%); copy this down the column by double clicking the
fill handle of D1
or
2) In E1 type 0.95; copy E1; select D1:D24000; use Edit | Paste Special and
specify Multiply, click OK; now delete E1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"capxc" wrote in message
...
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