I have a column of reference data that is the calculation of percentages
based on two other columns. I need to change the percentage column to actual
data instead of refernce data so i can sort by the percentages.

I think you mean that you want to fix the values. Highlight the column
containing the percentage calculations and click <copy>. Then click on
Edit | Paste Special | Values (check) | OK then <Esc>. This will have
converted the formulae into the actual values, so you can now sort the
data.

Hope this helps.

Pete

On Apr 9, 4:26*pm, Marshall <Marsh...@discussions.microsoft.com>
wrote:
> I have a column of reference data that is the calculation of percentages
> based on two other columns. I need to change the percentage column to actual
> data instead of refernce data so i can sort by the percentages.

Copy>Paste Special>Values>OK>Esc


Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 08:26:00 -0700, Marshall <(E-Mail Removed)>
wrote:

>I have a column of reference data that is the calculation of percentages
>based on two other columns. I need to change the percentage column to actual
>data instead of refernce data so i can sort by the percentages.