You are reading a single comment by @duncs and its replies.
Click here to read the full conversation.
-
Must be some bad data in there somewhere. Some non visible whitespace or similar that's breaking the conversion
duncs-
@ChainBreaker if it is white space then =trim(data) may remove some of it, if not you can use the substitute function as well.
Sam_w
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.