Keeping A Derived Column Of Numbers ?

[Bob]

Hello,

Using Excel 2007

Let's say I have a column of numbers in Column A that were derived
from some calculation done on numbers in Column B.

e.g. in A6: =B6/1000 etc.

I wish to delete Column B, but keep the derived Column A numbers.

How do I define the Column A numbers, now, such that they are not
dependent on Column B, which will no longer exist ?

Thanks,
Bob

 

[Dave Peterson]

You can convert the formulas to values (before you delete column B).

Select column A
Rightclick anywhere in that selection. Chose Copy.
Rightclick a second time and choose Paste Special. Check Values.

Then delete column B.

 

[Cimjet]

Hi Bob
Select your range "Column A" press copy keep highlighted then go to >Edit >Paste
Special and select "Values"
HTH
Cimjet