MS Excel / VBA help thread

You are reading a single comment by @chez_jay and its replies. Click here to read the full conversation.

•

Chalfie

dates/long numbers being corrupted

•

chez_jay in reply to @Chalfie

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.

About

Avatar for chez_jay @chez_jay started