Y
yuri.pershin
Hi, and thanks for your help.
I have a very simple task where I need to drag and drop messages from
outlook 07 to excel 07. All fields from Outlook (From, Subject, Size
etc) translate into rows of Excel without any problems, except for the
Received date.
The Received date in outlook shows in the following format: "Wed
12/18/2007 5:03 PM". But when I drag and drop that message to excel,
the Received date becomes "5:03 PM".
When I drag and drop a massage that's over a day old, the date in
excel becomes "Wed 5:03 PM".
I need excel to show the full date and time, but it seems to auto-
format the date depending on how old the message is. Perhaps this
issue is with Outlook, where it does not copy the full date?
Thanks for any suggestions.
I have a very simple task where I need to drag and drop messages from
outlook 07 to excel 07. All fields from Outlook (From, Subject, Size
etc) translate into rows of Excel without any problems, except for the
Received date.
The Received date in outlook shows in the following format: "Wed
12/18/2007 5:03 PM". But when I drag and drop that message to excel,
the Received date becomes "5:03 PM".
When I drag and drop a massage that's over a day old, the date in
excel becomes "Wed 5:03 PM".
I need excel to show the full date and time, but it seems to auto-
format the date depending on how old the message is. Perhaps this
issue is with Outlook, where it does not copy the full date?
Thanks for any suggestions.