Daniel, 100% sure? No...
I'm using Excel 2002, SP1 -----Original Message----- From: Daniel Chenault [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:42 PM To: Exchange Discussions Subject: Re: Directory Export Are you sure it's export dropping the leading zeros? What are you using to view the data? ----- Original Message ----- From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 3:18 PM Subject: Directory Export > Exchange 5.5, SP4 + hotfixes. > > When doing a directory export, we have a field titled Employee-Number (not > sure if this is a standard field or a custom one). This field is bounced > against the HR database to ensure no dupes and to update location data. > Some people's location data is not updating. Since this field is required > for this function, I exported the data to a .csv file and was checking it. > However, what I noticed is that I have anywhere from 3-digit numbers to > 7-digit numbers, because the export is dropping the leading zeroes. Is > there any way to force the export to export all 7 digits, even if they are > leading zeroes? > > Thanks, > > Jim Blunt > > _________________________________________________________________ > List posting FAQ: http://www.swinc.com/resource/exch_faq.htm > Archives: http://www.swynk.com/sitesearch/search.asp > To unsubscribe: mailto:[EMAIL PROTECTED] > Exchange List admin: [EMAIL PROTECTED] > _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED]
