Formatting User1 Field to MM/DD/YY?

[Josh H]

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!!!

 

[Sue Mosher [MVP-Outlook]]

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).

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers