I wouldn't use an apostrophe. Those are very difficult to clean up with
Edit|replace's.
I'd use:
edit|replace
what: = (equal sign)
with: $$$$$=
replace all.
That unique string $$$$$= should be easy to change back to a single equal sign.
gjcase wrote:
If you want the exact copy vs relative, simply place an apostrophe (')
ahead of the equals sign in the first formula, similar to adding
comments in some programming languages; this changes it from a formula
to text. Then copy it to the new cell, then remove the apostrophes from
both.
Incidentally, this works pretty well if you are trying to debug a long
formula and Excel won't let you enter the formula with a mistake in it.
You can "comment out" the entire formula, then copy it and work on
pices of the formula until you find the fix.
--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=509176
--
Dave Peterson