Hi Theo,
If you sent this message on the 10th of December, then the date
on your computer is incorrect. If you sent message on the 8th
and shut down then that could explain why the date is two days
earlier. Dates are timestamped when you send which may not be the
date that it actually leaves your computer. It is best to make sure
all messages are sent before you close your email application.
Since you used CDO (Communities) which is online, not really sure how much of
the above actually applies.
I thought I had the answer for you, but it testing did not duplicate
your result. You could always precede with a single quote.
What number format are you using for the column.
I thought it was a display option, but I could not duplicate your result.
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm