For a single sheet:

Enter 1.055 into an empty cell
Copy it
Select the range of data to change
Choose Edit-Paste Special-Values-Multiply from the menu
Click on OK

For hundreds of workbooks: unless the ranges are all consistent or can be
programmatically identified, you are looking at a manual process


"spence" wrote:

I have a range of cells with dollar values (no formulas) and am wondering if
there is any way to increase the values of all cells in the range by a
certain percentage, say 5.5%. I've got to do this in several hundred
workbooks and so would like to find a way to automate the process.
Unfortunately my range isn't currently named, though that could be remedied
if necessary.

Thanks in advance,
spence