Excel spread sheet

  • Thread starter TCSmith Lgl Asst
  • Start date
J

JulieD

Hi

type
1.15
in an usued cell somewhere and copy it
select the range you want to increase and choose
edit / paste special - multiply

Cheers
JulieD
please take a backup of your workbook before trying anything like this :)
 
J

Jason Morin

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
 
T

TCSmith Lgl Asst

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?
 
G

Gordon

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?
||
|| "TCSmith Lgl Asst" wrote:
||
||| How do I increase prices in an excel spread sheet by 15%?

If you right click on any empty cell, and choose Paste Special, what do you
get?
 
D

Dave Peterson

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.
 
T

TCSmith Lgl Asst

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
 
J

JulieD

very, very weird

could you try it in a brand new workbook ... type
5 in A1
1.15 in B1 and then copy this cell using control & C
click on A1 and choose edit / paste special / multiply
and let us know what happens

Cheers
JulieD
 
G

Gordon

JulieD wrote:
|| very, very weird

Especially as those options aren't even ON the "normal" paste special menu!
 
D

Dave Peterson

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)).
 
P

pwlyons

I just today started having the same issue. I would copy a range of
cells with data and formulas to a neighboring range and all the
formulas in the new (copied to range) were gone, being replaced by the
value, but evidently as "Unicode??"

If I select them one cell at a time and copy them and then do a "paste
special" the formulas option shows up, but if I attempt multiple cells
and do "paste special" I get paste as Unicode text or text. What
happened?? Is there an option setting that got altered? I am running
Excel 2000 build (9.0.2812)

any help would be appreciated...
 
Top