Try entering 1.03 in an empty cell.

Copy that.

Select the columns to change and editpaste specialmultiplyokesc.

Delete the 1.03 after.


Gord Dibben MS Excel MVP

On Fri, 12 Jun 2009 12:37:01 -0700, Lynn
wrote:

I have an Excel spreadsheet of a price list with various columns of currency
that I need to increase +3% and a separate sheet increased +6%. It's
originally set up in various sections that have multiple currency columns.
The normal formulation doesn't seem to work because some cells are merged.
This is a nightmare spreadsheet from a company that we sell for.
Anyone that can help me will be a SAINT.
With Appreciation,
LR