I have a spreadsheet with 15 columns. Column A is a list of automatic consecutivly fill-in numbers (i.e.) A1+1=A2, etc... I need to sort other columns without changing column A into a "value" rather than a formula. Is there anyway of doing this without loosing either/or the formula or the results of the formula in column A.