Outlook Outlook Distribution List Defaults

[BarbaraH69]

I use Outlook 2003 and have created a distribution list for 860 recipients utilizing excel. The distribution list works fine, however when it lists the members of the list it has the email in both the Name and E-mail columns. This makes it very difficult for me to determine which member it is that the email refers to.

It currently looks something like this

Name Email
(e-mail address removed) (e-mail address removed)

I want it to look like this:
Name Email
Smith, Andrew (e-mail address removed)

Can this be done automatically without me having to go in manually to every contact and edit the "Display As" field?

Thanks,
Barbara