Change 15/09/2003 format to text

[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.

 

[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

 

[Dastag]

Still no luck. Text to columns had no effect on the data.

 

[Ron de Bruin]

Hi Dastag

Send me a small workbook private
and I will look at it for you.