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

[James Womeldorf <jwomeldo@FASTENAL.COM>]

I think that will work except that if you try to do vlookups with another
spreadsheet that does not have the quotes in the cells then the lookups
fail.

-----Original Message-----
From: John Milardovic [mailto:milardj@SX.COM]
Sent: Monday, January 08, 2001 11:40 AM
To: SQR-USERS@list.iex.net
Subject: Re: question: format an excel file (.xls) inside sqr program


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