Maybe if you turn up the contrast you can see them. Sorry couldn't resist. What happens if you were to import just one of the records back. Do the zeros reappear?
----- Original Message ----- From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]> To: "Exchange Discussions" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:54 PM Subject: RE: Directory Export > It's not Excel doing it...I opened it in Notepad and the leading zeroes are > still missing. > > -----Original Message----- > From: Daniel Chenault [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:50 PM > To: Exchange Discussions > Subject: Re: Directory Export > > > 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] > > _________________________________________________________________ > 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]
