Hi

Do you want to apply the same formula to these cells, or what? You can make
use of a macro to achieve your goal, but the macro itself will be difficult
to write without any guidelines?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Cowtoon" wrote:

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