Select the Values from cells, click Copy. Move to another location,
right-click choose Paste Special - Values (can also use Edit - Paste Special).

Let us know if the information is helpful.

"Joe G" wrote:

I have a column of derived data. I want to copy the absolute value of the
cells, not the formulas, to another place on the spreadsheet so I can sort
them from greatest to least.