P
pkeegs
I have a large file imported from another source into Excel (2003) with a
column of dates. The date column format is eg Mar. 09 1963 but some dates
only have the year or no date. I want to convert dates to format dd/mm/yyyy
or where there is no full date, to return just the year yyyy. Where the full
date is available I can convert using formulas or Text to Column, but I have
trouble where there is just the year. Is there a method without having to
convert manually all the dates with only the year?
column of dates. The date column format is eg Mar. 09 1963 but some dates
only have the year or no date. I want to convert dates to format dd/mm/yyyy
or where there is no full date, to return just the year yyyy. Where the full
date is available I can convert using formulas or Text to Column, but I have
trouble where there is just the year. Is there a method without having to
convert manually all the dates with only the year?