thanks for the tip , it worked perfect!

"Ken Wright" wrote:

Do you want to lose the existing values?

1) Keeping existing values, simply use another column and use a formula such
as =A2*1.1 and copy down.

2) Replacing existing values, put 1.1 in any empty cell, then copy that
cell. Select all your values and then do edit / paste special / values &
multiply

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------


"mowerman" wrote in message
...
at our store we have price sheets in excell and i want to raise the list
prices all at one time to 10% higher . can i do this and how