When I copy and paste the following cell

=IF('13'!B13>0,'13'!B13,NA())
to the remainder of the days of the month, what I get is

=IF('13'!B14>0,'13'!B14,NA())
=IF('13'!B15>0,'13'!B15,NA())
etc
But what I want to get is

=IF('14'!B13>0,'14'!B13,NA())
=IF('15'!B13>0,'15'!B13,NA())
etc
I'd even settle for

=IF('13'!B13>0,'13'!B13,NA())
=IF('13'!b13>0,'13'!B13,NA())
etc
whereafter I could just modify the formulas individually by hand.

But Excel just assumes a certain kind of translation. So I have to undo its translation and change it to the desired one.

Is there a way to override the translation effect when cutting and pasting formulas? Or ideally to modify it to go a certain way rather than another?

Thanks.