| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change reference data to numbers?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change reference data to numbers?
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 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I change reference data to numbers?
CopyPaste SpecialValuesOKEsc
Gord Dibben MS Excel MVP On Wed, 9 Apr 2008 08:26:00 -0700, Marshall 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to change change cell reference to Absolute reference? | Excel Worksheet Functions | |||
| change change cell reference to Absolute reference | Excel Discussion (Misc queries) | |||
| Relocating reference numbers for many blocks of data | Excel Discussion (Misc queries) | |||
| data label reference change | Charts and Charting in Excel | |||
| how can I change the scale of the numbers in my chart data table? | Charts and Charting in Excel | |||
Hybrid Mode
