Copy the formula in the f(x) box at the top of the worksheet. Select the
cell the use CNTL - C. go to 2nd worksheet select the cell where you want to
pastt the formula and click in f(X) box and type Cntl - V.
One way.
Select your column of formulae
Ctrl+H to invoke Find and Replace
Find =
Replace #
Replace All
Copy your formulae and paste to new sheet.
Do a Find and Replace of # with = on both sheets.