changing formulas

X

xcel user

Can part of a formula - which is a defined name for another cell - be changed
by a find/replace function?
 
X

xcel user

Hi Stephen,
thanks for taking the time to respond. I have tried that already - i am
using excel 2003 - and excel states it can not find the data.

for example - what i want to change is =(acFebTot/a18)
to -(acMarTot/a118)

thanks again ~ Susan
 
S

Stephen

Presumably "acFebTot" is the cell name you have and "acMarTot" is what you
want to replace it with in a formula. I have done this many times using
Find/Replace (using versions 2000 and 2003). Are you sure you didn't mistype
"acFebTot"? (I notice two typos in your reply below!)
 
Top