=mid(cell number, 3, len(cell number) - 3)
they are not always 11
use this:Code:=mid(cell number, 3, len(cell number) - 3)
CSV isn't a very forgiving format. You'll need to tag a character onto the beginning that won't "bug" you that will force the CSV to treat it as text and not "convert" it for you during save/import.
="'"&MID(C8, 3, LEN(C8) - 3)
This will result in:
'62886E108
When I use that formula, then copy/paste values to remove formulas, save, reopen, I see the same value as prior to close, so it's working for me. No ideas as to why your mileage is different.