You can use code or another workaround
do editreplace and in the find box put an equal sign = then in the replace
with box put
^^, select replace all, close dialogue box, now copy and paste, then reverse
and replace ^^ with equal sign
done!

--
Regards,

Peo Sjoblom

(No private emails please)


"cyn22" <u16589@uwe wrote in message news:58b264dacabdc@uwe...
Paul B,

That works great...however, how do I now go back and put that dollar sign
after the row in a large number of cells? I have a bunch of cells I need
to
change. I know you can replace a number or letter with the edit/replace
function, but can I blanket add something?

Paul B wrote:
cyn22, maybe using the formula ='10u'!A$2 will work for you, does this
help?

How do I copy a formula from a group of cells to another group of cells
without excel editing the formula?
[quoted text clipped - 5 lines]
formula to ='10U'!A16. I know I can copy from the formula bar, but what
if I
want to do this for a large number of cells? It would take me forever.
Help!