Change 15/09/2003 format to text

D

Dastag

I was provided a spreadsheet that contains multiple date fields. Some of the
values will convert using format options, others will not. Those that will
not change all seem to be in a European format with the day of the month
listed first. How can I convert these fields to a date value that will
convert to a serial number when I format them as text? By the way, the real
issue is that Access will not import these values correctly. I have yet to
get any of these spreadsheets in cleanly.

Thanks in advance.
 
R

Ron de Bruin

Try this on a copy of your worksheet

Select the cells with dates
Data>Text to columns in the menubar
Next
Next
Select Date and choose DMY
OK
 
Top