Quote:
Date format is something you set on the field itself in excel. Not in windows generally.
Just select the offending fields and change the format.
Doesn't work like that. The Word macro uses Excel via a VBA macro to pull apart the .csv file. You never see Excel, thus you don't get the chance to select formatting or anything.
Even then it still mucks it up. Try entering 01/12 in Excel and then change the format back to normal and you get 38687 since it's already converted it to it's internal date representation (number of days since 1900 I think). The only way to do it is to put an apostrophe so Excel leaves it alone. But I can't do that.
_________________________
Christian
#40104192 120Gb (no longer in my E36 M3, won't fit the E46 M3)
Previous Topic
Index
