To convert all formulas to their values:
Select the whole range of cells Ctrl+C (for copy) right(!) click one of
the cells 'PasteSpecial...' select 'Values' 'OK.
Micky


"Howard" wrote:

I hope I can explain this well enough to be understood. I have a LONG
column. Each cell in this column contains a formula (=(M331/1000000)+37)
which returns a value to the cell. However, when you click on a completed
cell, you get the formula in the formula bar.

What I would like to do; after I have completed all my data input; is to
highlight the cells in this column, and replace the formula with the value in
each cell, so that if I want to use this value somewhere else, I copy the
value, not the formula.

Thanks.
--
Howard