I need to add .12 cents to every item in a column on my pricelist is there an easier way to do this?
C claudia Aug 11, 2008 #1 I need to add .12 cents to every item in a column on my pricelist is there an easier way to do this?
D Don Guillett Aug 11, 2008 #2 Put .12 in any unused cell copy that cell select the range to change edit paste special add
M Mike H Aug 11, 2008 #3 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
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
