add formula to existing cell

[briankimberly]

i have a range of numbers. instead of referencing it by its ref (A1) i would like to go into each sell and add +$C$1 to all the cells in column A. so if a1= 15 instead of referencing it in another cell D1 with formula A1+$C$1 i would like A1 to show =15+$C$1

 

[storm8]

I don't think thats possible but you can add extra column showing the prev calc as number

 

[briankimberly]

yeah figured that was the case ok thx