how to add .12 cents to every item in a column

  • Thread starter Thread starter claudia
  • Start date Start date
C

claudia

I need to add .12 cents to every item in a column on my pricelist is there an
easier way to do this?
 
Put .12 in any unused cell
copy that cell
select the range to change
edit
paste special
add
 
Hi.

Put 0.12 in a cell and copy it. If your cell is formatted as currency be
sure to use the same format on this cell or you'll lose your formats.

Select your range and then
Edit|Paste special
Select add
Click OK

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No cents 3
Calculation Problem 2
Splitting dollars and cents 7
In adding a single column, it's always out 1 cent, why? 3
Help with calculation 1
formatting a cell 2
Sum totals - Help 1
Rounding cents 3

Back
Top