You are reading a single comment by @Chalfie and its replies.
Click here to read the full conversation.
-
Ah yes the numbers are long enough to be interpreted as [edit] floating point numbers. No dates though?
I'd probably write a custom CSV parser in VBA which treats everything as strings by inserting'.
But if you need to do arithmetic on numbers that big, Excel is probably the wrong tool. -
Opening in power query should fix that though shouldn't it? Format the raw CSV as needed
chez_jay
aggi
@Chalfie
dates/long numbers being corrupted