Claus Busch wrote:

Hi Terry,

Am Sun, 27 Apr 2014 17:29:58 +0100 schrieb Terry Pinnell:

I could tediously change all the general entries by editing say 1960
to 1/1/1960, but there has to be an easier way!

the above is a possibility.
Or you write in G1:
=IF(C1<"",YEAR(C1),F1)
and copy down
Then copy the data in column G and paste the values to F


Regards
Claus B.

Thanks Claus.

--
Terry, East Grinstead, UK