Remove Formula

  • Thread starter Thread starter Gerry
  • Start date Start date
G

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
 
col B click on the column header>copy>edit paste/special values>delete 1st
column
 
Thank you very much. That worked a treat.

Gerry

Don Guillett said:
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)
Click to expand...
 
Back
Top