Did you copy the 1.15 from the formula bar or did you copy the cell?

Select your cell with the 1.15 in it and hit edit|copy (or just ctrl-c).

I could get that other dialog if I copied from the formula bar, too (or from a
different instance of excel (or a different application -- like notepad)).



TCSmith Lgl Asst wrote:

Yes I did, I used a cell on the same work book just beneath the column I
wanted to adjust... I tried using different cells as well, but "multiply"
didn't show up in the "paste special" menu

"Dave Peterson" wrote:

Did you use a helper cell on the same worksheet? (just out of the way
somewhere)

It kind of sounds like you used a cell in a different workbook that was open in
a different instance of excel.



TCSmith Lgl Asst wrote:

Thanks, but there must be a problem with the formatting.

After copying "1.15" then going to "edit" and "paste special" the menu
doesn't include "muliply".... only "text" and "unicode text"

Is there a remedy for this formatting situation?

"Jason Morin" wrote:

1. Key 1.15 into an open cell.
2. Copy that cell.
3. Select the range of prices.
4. Go to Edit Paste Special. Click Multiply. OK

HTH
Jason
Atlanta, GA

-----Original Message-----
How do I increase prices in an excel spread sheet by 15%?
.



--

Dave Peterson


--

Dave Peterson