Re: question: format an excel file (.xls) inside sqr program

[John Milardovic <milardj@SX.COM>]

I thought I remembered a post in the past that said to place a single quote
before the number to force it to be treated as text:

        '00010

You might want to try that.

HTH

> -----Original Message-----
> From: Fetzik, John [SMTP:JFetzik@SANDC.COM]
> Sent: Monday, January 08, 2001 11:57 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: question: format an excel file (.xls) inside sqr program
>
> Using Excel 97 SR-2 I get a single field with the string 00010 00010 in
> it.
> Sounds like Microsoft changed the defaults yet again with Office 2000.
>
>
> > -----Original Message-----
> > From: James Womeldorf [mailto:jwomeldo@FASTENAL.COM]
> > Sent: Monday, January 08, 2001 10:48 AM
> > To: SQR-USERS@list.iex.net
> > Subject: Re: question: format an excel file (.xls) inside sqr program
> >
> >
> > Unfortunately that doesn't work for me.  I am using Excel 2000 and am
> > beginning to wonder if this is a new 'feature' of that version.
> > Would someone else who is not on Excel 2000 try loading the
> > attached file?
> > When I load it I get 2 cells, both of which contain
> > 10