Select all columns to be updated
EditCopy
EditPaste special check Values

HTH
--
AP

"GregR" a écrit dans le message de news:
...
I have a spreadheet that has a column, titled "Running Totals". This
column moves each month after the first of the month. When I move that
column, I want to automatically convert any formulas to the left of the
column into their numeric value. How? TIA

Greg