I recently came into a situation that I had not seen before in PDF to Excel conversion. The dates in PDF are correct. But when converting to Excel , some dates with single months like Jan or June etc, covert the date as DD/M/YYYY. If the month is two digits like, Oct thru Dec, then the date conversion is correct.
I can correct this using Text to columns and highlighting the date column and then in Fixed Width use DMY and it correctly changes the format to US format for all of the two digit months.
My guess is that the PDF has the issue and not excel. Excel must be seeing in the PDF conversion the MDY as DMY.
Has anyone seen this before? If so, did you find a solution for the PDF so that this converts correctly in all Excel conversions, or did the solution reside in the Excel side?
Thanks pick
Bookmarks