Remove Formula

[Gerry]

Recently I got excellent help on how to fix my dates which were entered
improperly. Worked like a dream. Now I need help on how to resolve the
current problem.
I have the old date column A - ddmmyyyy
I have beside, in Column B, it the proper converted date as yyyymmdd with
the formula in that column cell.
If I remove the first column (A) the second column data disappears.
If I remove the formula from the second column (B) that data disappears.

I only want to have one date column left - the second (B) which holds the
formula - but I don't want the formula any more.

Any ideas?

Many thanks

Gerry

 

[Don Guillett]

col B click on the column header>copy>edit paste/special values>delete 1st
column

 

[Gerry]

Thank you very much. That worked a treat.

Gerry

col B click on the column header>copy>edit paste/special values>delete 1st
column
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

Glad to help.