Quote:
I would open up Excel and search in its preferences for something like automatic input interpretation and turn it off. That is, I'm pretty sure that there's an option somewhere that tells Excel to translate input to what it thinks it is, including stuff like turning strings with at-signs into mailto links and so on. I would expect that Excel would honor that setting even in a macro where you don't see the Excel GUI.

I did have a pretty good look and google around for info on setting this, but could find anything. I also would have expected Excel to have the option at least. I will look again.

I sent an email to the author but no reply, so I did a bad thing and cracked the macro password. By doing that I can stop the macro part way and fix things up a bit using a custom format. It's not a total fix though since by that stage Excel has already munged the xx/yy formats into it's serial number and I can't fix everything unless I do it manually.

I guess another option (that I just thought of) is write some simple perl to fix up the CSV before loading it.
_________________________
Christian
#40104192 120Gb (no longer in my E36 M3, won't fit the E46 M3)