The best procedure depends on how many you're trying to copy.

For one or two, you can select the *entire* formula in the formula bar,
right click and choose "Copy", then hit <Enter.
Now you can navigate to wherever you wish, and Paste it as many times and/or
places you want.

For numerous formulas, *unformulate* them by replacing the equal sign with a
unique character(s), by using "Edit & Replace", and then copy and paste as
regular text to your new location, and then reverse the procedure to return
the equal sign and make them formulas again.

Make sure the unique replacement is *unique*.
Something like carats and backslashes:
^\^\^
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"Nickchups" wrote in message
...
Hi there,

Does anyone know how I can replicate formulas (verbatim) between
difference
excel files? I've tried to cut and paste between the separate files, but
to
my dismay it makes a reference to the original file.

Regards,
Nickchups