i knew not to use a $, but the character addition was what i needed

--


Gary


"JMB" wrote in message
...
Not sure I'd use a $. Consider the formula

=$E$5
becomes
$$E$5

trying to change it back generates an error on my machine.



"Jim May" wrote:

Gary:

I think the practice is to

Highlight/Select your range (of formulas) and to the Edit, Replace
routine where, say:
In the Find What Box enter =
and in the Replace with $

Then
Copy and paste -- Then reverse Process in the Destination and the Source!!

HTH,
Jim May



"Gary Keramidas" wrote:

i have a workbook with about 300 lines of formulas. i would like to copy
them to
another workbook. but when i do, the formulas always link back to the
original
workbook. any way around this?

--


Gary