Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel spread sheet
How do I increase prices in an excel spread sheet by 15%?
|
#2
|
|||
|
|||
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 :) "TCSmith Lgl Asst" <TCSmith Lgl wrote in message ... How do I increase prices in an excel spread sheet by 15%? |
#3
|
|||
|
|||
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%? . |
#4
|
|||
|
|||
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%? |
#5
|
|||
|
|||
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%? . |
#6
|
|||
|
|||
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? -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
Just "text" and "uni text" no multiply in there
"Gordon" wrote: 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? -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#10
|
|||
|
|||
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 "TCSmith Lgl Asst" wrote in message ... Just "text" and "uni text" no multiply in there "Gordon" wrote: 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? -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#11
|
|||
|
|||
JulieD wrote:
|| very, very weird Especially as those options aren't even ON the "normal" paste special menu! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#12
|
|||
|
|||
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 |
#13
|
|||
|
|||
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... -- pwlyons ------------------------------------------------------------------------ pwlyons's Profile: http://www.excelforum.com/member.php...o&userid=25053 View this thread: http://www.excelforum.com/showthread...hreadid=350441 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Starting MS Excel with a worksheet other than SHEET 1 | Excel Worksheet Functions | |||
How do I export excel spread sheet to my Palm T3? | Excel Discussion (Misc queries) | |||
CAN YOU HAVE THE TOP OF AN EXCEL SHEET HAVE DIFFERENT COLUMN WIDT. | Excel Worksheet Functions | |||
Removing single quote from an excel sheet | Excel Discussion (Misc queries) |