Global formula
 

How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.

George,
Can you use the EUROCONVERT function in an adjacent cell then autofill the
rest of the way? I wonder if you can build a macro that looks at each cell
and as long as the value is 0 have the macro insert the conversion formula
then stop doing so as soon as it sees a zero value. I look forward to someone
posting that knows how.
Gary

"George" wrote:

How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.