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

I need to add .12 cents to every item in a column on my pricelist is there an
easier way to do this?
--
claudia

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

Put .12 in any unused cell
copy that cell
select the range to change
edit
paste special
add

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"claudia" wrote in message
...
I need to add .12 cents to every item in a column on my pricelist is there
an
easier way to do this?
--
claudia

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

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

"claudia" wrote:

I need to add .12 cents to every item in a column on my pricelist is there an
easier way to do this?
--
claudia