| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
number grab
|
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
number grab
Many thanks to everyone...
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
| Generating (in a random order)each number once from a given number | Excel Worksheet Functions | |||
| Change number format from text to number? | New Users to Excel | |||
| vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Hybrid Mode
