I have a really annoying issue due to some stupid data that I have to work with - in column A there is a date and time - not in a proper excel format - this is how I get the data. I want to extract the date part only so do the formula in column b then use text to columns to force it into date format - however if the date is a month with 2 numbers such as Oct =10 (see last 2 rows) then my original formula drops the last digit off the date and the text to columns doesn't work - I have been resolving this manually nut I KNOW there must be a better way (other than changing the source data as that is outside my control)
Any thoughts?
Thanks
Bookmarks