CSV Date issue

[pmw19800]

hello all

the attached is a CSV down load that will be pasted into another sheet,

i have an issue with the date in col P - I need to covert this into dd/mm/yy format

i have no idea why the date is like this, and i cant seem to get the date to change


Thanks for your time

[TMS]

In a helper column, put this formula in row 2 and copy it down:

Please Login or Register  to view this content.

[CARACALLA]

Select date in column P
Text to columns
Delimited
next
next
Select Date
Choose YMD
Finish
Format yyyy/m/d
Change format with custom format
dd/mm/yyyy

[TMS]

Or, all in one go:

Please Login or Register  to view this content.

[TMS]

Looks like column B has dates in it too.

[pmw19800]

thank you, this works great

[pmw19800]

I could not this to work, i had tried this several times

[AliGW]

Provide a sample workbook that shows the issue.

[TMS]

Please see the attached file.

[TMS]

The thread is marked solved. Which solution doesn't work for you?



Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.