Well, then, I guess it IS Exchange doing it. You'll have to contact MS about
it then.

----- Original Message -----
From: "Blunt, James H (Jim)" <[EMAIL PROTECTED]>
To: "Exchange Discussions" <[EMAIL PROTECTED]>
Sent: Friday, February 22, 2002 4: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]

Reply via email to