View Single Post
  #2   Report Post  
Oliver Ferns via OfficeKB.com
 
Posts: n/a
Default

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