Adding a value to a range of cells

[BillBeachwood]

Hi guys,

I have column that contains about 50 entries of different dollar figures. How can I make each cell be .43 cents less than it currently is without setting up a different column that has the new values. I'd like to keep it all in the same column.

(Does my question even make sense?)

-Bill

[darkyam]

Type .43 in a different cell. Copy that cell, then highlight the range of cells that you wish to subtract .43 from, Paste special, select Subtract.

[BillBeachwood]

Honestly, I joined this site 2 days aga and I cannot stress what an amazing resource it has been. I wish I had joined a long time ago. I have a ton of catching up to do. At least I feel a lot less lost. I can't thank you guys enough!

-Bill

[darkyam]

You're very welcome. Thanks for the feedback.