I have a strange need to copy and paste a formula from one page to another, I need to treat it like it has $ signs on cell references without actually having it there.

So my formula which is going to change frequently is currently

=TEXT(N6,"MMM YYYY")&"
Avoidance: "&TEXT(O6,"$#,###,###") &" ("&TEXT(P6,"###.0%") & ")
Spend: " & TEXT(Q6,"$##,###,###")

Basically I am trying to paste it to the top row of another sheet and then paste it down, and if the $ is there it will mess up the paste down.

My best guess is to use the $ in my formula copy and past the formulas then use a find and replace formula to get rid of the $, and then finish it with a paste down formula.

Anyone want to tell me a better way.
Please!