Excel spread sheet

[TCSmith Lgl Asst]

How do I increase prices in an excel spread sheet by 15%?

[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

"TCSmith Lgl Asst" <TCSmith Lgl Asst@discussions.microsoft.com> wrote in
message news:132CB998-4CAE-4BDA-A226-BFDC9D435D5F@microsoft.com...
> How do I increase prices in an excel spread sheet by 15%?

[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

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

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

"TCSmith Lgl Asst" wrote:

> How do I increase prices in an excel spread sheet by 15%?

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

"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%?
> >.
> >
>

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

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

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



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

[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



"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
>

[TCSmith Lgl Asst]

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

[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

"TCSmith Lgl Asst" <TCSmithLglAsst@discussions.microsoft.com> wrote in
message news:6D172CF9-5BA0-4809-BDA9-92E40087C0B4@microsoft.com...
> 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
>>
>>
>>

[Gordon]

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

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



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

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