Changing numbers from forumla to static

I used a formula to assign a set of numbers to a list of data in order to
identify the data in the row. The formula adds 1 to the value in the cell
above it to creat the number for each row. Now I want the resulting numbers
to stay with the data in its row when I change the position of the that row
relative to the other rows. Can I somehow detach the results numbers from
their formula so that they don't change when I sort the data?

Copy the cells then Paste Special>(in place)Values>OK>Esc.


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 12:01:01 -0700, newmoon <newmoon@discussions.microsoft.com>
wrote:

>I used a formula to assign a set of numbers to a list of data in order to
>identify the data in the row. The formula adds 1 to the value in the cell
>above it to creat the number for each row. Now I want the resulting numbers
>to stay with the data in its row when I change the position of the that row
>relative to the other rows. Can I somehow detach the results numbers from
>their formula so that they don't change when I sort the data?