I'm using SharePoint 2007. I have created custom-list.
The list contains one column from "Person and group" type, show field: E-mail.
I fill in data in the list column and export this list to excel list.
In the Excel list, I see the Email with employee number.
It looks like: firstName_LastName_CW@bmc.com;#397
How can I export a custom list into Excel without the number?