Formatting User1 Field to MM/DD/YY?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Josh H - 17 Nov 2006 14:03 GMT

I just recently imported an Excel sheet with all my contacts into Outlook for
better management. I have a couple date columns that I need to keep in
Outlook, for at a glance tracking of when I last talked to the person, and my
follow-up date. When I used the field map, I mapped my spreadsheet date
columns to User1 and User2. When I'm in the column view of Outlook, my dates
are displayed as example:

2006-11-15 00:00:00

I want it in MM/DD/YY format.

When I right click and format the column, the only option I have to select
is Text. The spreadsheet was formatted Date.

Any ideas how to fix this?

Thanks!!!

Reply to this Message

Sue Mosher [MVP-Outlook] - 17 Nov 2006 15:04 GMT

User1 is a text property. It has no formatting options associated with it. Any formatting has to be done at the time the data is entered in that property.

At this point, you would have to (a) change the data in the Excel sheet and redo the import or (b) write code to update the value it that field for all items or (c) write code to copy the data into a custom date/time field (see http://www.outlookcode.com/d/code/convertfields.htm).

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I just recently imported an Excel sheet with all my contacts into Outlook for
> better management. I have a couple date columns that I need to keep in
[quoted text clipped - 13 lines]
>
> Thanks!!!

Reply to this Message