Nope, formula will pretty much always adjust relative to where you are pasting them unless you convert them into a fixed text string first.

Dom