You are reading a single comment by @ChainBreaker and its replies.
Click here to read the full conversation.
-
can you paste into notepad and then back in again?
(post dredge)
Did the whole lot onto notepad. The amendable version has no issues swapping formats. The borked ones are still borked.
Ive even copied it to a new sheet. Fresh column. Copied from the Notepad to the new sheet.
ChainBreaker-
Can you share the workbook (obviously without the financial data...), I have come across most date issues at some point in the past, but there are so many it is hard to diagnose!
Also does your bank give you other download options?
-
Must be some bad data in there somewhere. Some non visible whitespace or similar that's breaking the conversion
Sam_w
duncs
can you paste into notepad and then back in again?
(post dredge)