Text to date format

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top