Re: dates corrupted on import (2000 SP3)

Reply

Thanks for all the great ideas, chaps. As there’s no great rush on this (it’s no big deal to do the copy + paste by hand once a month) I’m going to have some fun with it (and maybe learn a bit.)
Am trying turning the dates which are dates (ie not text) into serial number dates and defying xl, or vba, to ‘Americanise’ them, before applying a date format the way round I want.
I figure that what we need is a ‘Copy Special’ a la WYSIWYG just as we have 10 kinds of Paste Special *grin*.
Am curious about the New Zealand dictionaries: have the real ones got all the words upside down?

Quote