You can do editreplace to replace parts of a formula
To change from relative to absolute you need a macro unless you want to edit
each cell, press Alt+ F11, click insert module and paste in the following
Sub ReltoAbs()
Dim Cell As Range
For Each Cell In Selection
Cell.Formula = Application.ConvertFormula(Cell.Formula, xlA1, xlA1,
xlAbsolute)
Next
End Sub
press alt + Q to close the editor, sabve the workbook, select the range you
want to change, do alt + F8 and run the macro (you can also put it in the
personal.xls to make it available for all workbooks)
Regards,
Peo Sjoblom
"Pat" wrote:
Win XP/Excel 2002
You guys are great!
So, two question: Is there a way to globally replace certain numbers within
a formula.
2nd: Without editing each formula, etc - is there a function that I can
make the formulas cell references absolute?
Thanks!
Pat Joram