number grab
 

Hi

I've been a bit stupid. I have about 6 columns of price data where column R
is a net selling price. I've entered these column R numbers as fixed
numbers.

This is my mistake because I've added a formula to the P column which knocks
a percentage off the R column number to give me my purchase price.

What I should have done was to have the fixed numbers in the purchase price
column P for the selling price column R to derive values using a formula.
The other way round in other words.

I really don't want to have to work through 650 lines making a note of all
the formula determined values in Column P so that I can re-enter them as
fixed values and apply a formula to column R.

Is there a way of 'grabbing' the numbers in column P, that currently result
from a formula, converting them to fixed numbers that are not based on a
formula?

Thanks
David

number grab
 

It sound as if you want to use Copy then Paste Special Values

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"David" wrote in message
...


Hi

I've been a bit stupid. I have about 6 columns of price data where column
R
is a net selling price. I've entered these column R numbers as fixed
numbers.

This is my mistake because I've added a formula to the P column which
knocks
a percentage off the R column number to give me my purchase price.

What I should have done was to have the fixed numbers in the purchase
price
column P for the selling price column R to derive values using a formula.
The other way round in other words.

I really don't want to have to work through 650 lines making a note of all
the formula determined values in Column P so that I can re-enter them as
fixed values and apply a formula to column R.

Is there a way of 'grabbing' the numbers in column P, that currently
result
from a formula, converting them to fixed numbers that are not based on a
formula?

Thanks
David

number grab
 

columns(4).value=columns(4).value

--
Don Guillett
SalesAid Software

"David" wrote in message
...


Hi

I've been a bit stupid. I have about 6 columns of price data where column
R
is a net selling price. I've entered these column R numbers as fixed
numbers.

This is my mistake because I've added a formula to the P column which
knocks
a percentage off the R column number to give me my purchase price.

What I should have done was to have the fixed numbers in the purchase
price
column P for the selling price column R to derive values using a formula.
The other way round in other words.

I really don't want to have to work through 650 lines making a note of all
the formula determined values in Column P so that I can re-enter them as
fixed values and apply a formula to column R.

Is there a way of 'grabbing' the numbers in column P, that currently
result
from a formula, converting them to fixed numbers that are not based on a
formula?

Thanks
David

number grab
 

David wrote:
Hi

I've been a bit stupid. I have about 6 columns of price data where column R
is a net selling price. I've entered these column R numbers as fixed
numbers.

This is my mistake because I've added a formula to the P column which knocks
a percentage off the R column number to give me my purchase price.

What I should have done was to have the fixed numbers in the purchase price
column P for the selling price column R to derive values using a formula.
The other way round in other words.

I really don't want to have to work through 650 lines making a note of all
the formula determined values in Column P so that I can re-enter them as
fixed values and apply a formula to column R.

Is there a way of 'grabbing' the numbers in column P, that currently result
from a formula, converting them to fixed numbers that are not based on a
formula?

Thanks
David



High light your numbers, copy, then paste special, values only.

gls858

number grab
 

David

You can copy column P and EditPaste SpecialValueOKEsc.

You could do it in place on column P or to a new column.


Gord Dibben MS Excel MVP

On Thu, 20 Jul 2006 20:26:13 +0100, "David" wrote:



Hi

I've been a bit stupid. I have about 6 columns of price data where column R
is a net selling price. I've entered these column R numbers as fixed
numbers.

This is my mistake because I've added a formula to the P column which knocks
a percentage off the R column number to give me my purchase price.

What I should have done was to have the fixed numbers in the purchase price
column P for the selling price column R to derive values using a formula.
The other way round in other words.

I really don't want to have to work through 650 lines making a note of all
the formula determined values in Column P so that I can re-enter them as
fixed values and apply a formula to column R.

Is there a way of 'grabbing' the numbers in column P, that currently result
from a formula, converting them to fixed numbers that are not based on a
formula?

Thanks
David

number grab
 

Many thanks to everyone...