Converting a formula to data

  • Thread starter Thread starter Howard
  • Start date Start date
H

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.
 
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
 
Howard said:
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.
Click to expand...

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.
 
Back
Top