"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

Howard:

I believe you can achieve the desired results via the following:

Insert a new column (does not need to be adjacent but would probably be best
as you're going to either hide or delete the columns containing the formula).
Copy the entire column,
Select newly inserted column,
Right Click - Copy
Paste Special
Select Values.
Now you have just the values.