Hi there,
Simple problem here. A dataset exports from a system in .csv format. See attached column A where problem exists.
I am not able to change this into a date. Even using the convert text to columns trick - with that Excel has a hard time with the dates where the day or month value is a single digit.
is there a way I can easily change this date to just a date or a date and time separated?
Having a bit of a hard time here.
Thanks so much!
Bookmarks