Yes, Excel has a tendency to do that to leading 0's. Open it with notepad or your favorite text editor/viewer - something that just reads the raw datastream without trying to interpret it.
----- Original Message ----- From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 4:46 PM Subject: RE: Directory Export > 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] > _________________________________________________________________ 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]
