Hi Howard
Just highlight the cells in that column, then press Copy Paste Special and
select Values.
That should replace all the formulas with your values.
P.S. All the formulas will be removed.
HTH
John
"Howard" wrote in message
...
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