I am really new at this.

Can someone tell me how to do this:

I got column A & B with formulas using cells from Column C onwards.

My aim is to keep A & B constant as on month basis, I have to dump new data and format the data in Column C onwards.

Formula in A & B gives #NA because of the formating.

Anyway of avoiding this.

Hope I am clear

Thanks in advance