Converting a formula to data

[Howard]

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.

 

[John]

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

 

[מיכ×ל (מיקי) ×בידן]

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

 

[Thalarctos]

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:

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.