In a word, No!! All I can suggest is you reformat the cells when the file
is opened. I tried preceeding the date with a ' and Excel got shot of the '
AND the leading 0. The only other suggestion I have is to save as a TXT
file and use the text import wizard to format the column as text, then the
leading 0 remains but Excel doesn't recognize them as dates until you * by
1. Bit of a pain innit?
Hth,
Oli
--
Message posted via
http://www.officekb.com