Using Excel 97

I have a number of spreadsheets where I have to do a convert all amounts
with a calculation. Is there a global way to do this. There's quite a few
cells and spreadsheets ... would be nice to not have to tell each cell to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana