suppose u have data
A1 B1
100 =A1*10/100

drag it down.

then copy the values in B1 , select A1 then Go to Edit | pastespecial
| values | subtract | ok



On Sep 11, 11:43*pm, Eagledove
wrote:
I would appreciate help on this matter otherwise i have to do it manually.. *

cheers
Michelle