Adding a fixed value to a range of cells

[akatz]

Hi, I'm working with a column of library fines in a spreadsheet and I'd like to add .50 (cents) to each cell automatically every week (apparently this is currently being done manually). So I'd like a formula that will add .5 to the range of cells and replace their current value. I'm guessing this is something basic but I can't find the answer in any microsoft manual I have access to.
Thanks!
abigail

 

[wigi]

Hi

Put the number 0.5 in a cell. Copy that cell. Select the cells to be augmented. Choose Paste Special, and in the next dialog screen choose Add. OK your way out. Delete the cell with 0.5.

Wigi

 

[akatz]

Hooray! thanks Wigi