View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default Excel how do I add a flat 10.00 in a column with 10 entries

Enter 10 in some empty cell and copy that cell. Then select the
number you want to change, go to the Edit menu, choose Paste
Special, select the Addition option, and click OK. You may now
delete the cell in which you entered the 10.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jdetuya" wrote in message
...
Need to add a a flat amount of 10.00 in each entry ex
112.00
134.00
154.00
ect