RE: [sqr-users] Excel output importing incorrectly

["Bryson, Steven" <Steve.Bryson@phh.com>]

Exactly what I needed....Thank you!!!

-----Original Message-----
From: don.barclay@srs.gov [mailto:don.barclay@srs.gov]
Sent: Wednesday, May 07, 2003 12:24 PM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] Excel output importing incorrectly


Steven,
We've found that if we add an equals sign and a double quote before the 
variable and a double quote after the variable, excel will not try to 
auto-format the field.  I got this trick from this list some time ago.

let $variable = '12-01'
let $excel_variable = '="' | $variable | '"'

write 10 from $excel_variable:10

Don Barclay
Westinghouse Savannah River Co.
Aiken, SC





"Bryson, Steven" <Steve.Bryson@phh.com>
Sent by: sqr-users-admin@sqrug.org


05/07/2003 11:03 AM
Please respond to sqr-users

 
        To:     "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>
        cc: 
        Subject:        [sqr-users] Excel output importing incorrectly


When using Excel output certain numbers are converted to dates within 
Excel
meaning a number that is 12-01 will display as Dec-01. I am aware the text
is fine and this is an Excel problem in which it converts it to a date 
when
it should be a text field.  Is there any way to code a workaround without 
a
user having to import the file and format?



"The sender believes that this E-mail and any attachments were free of any
harmful and malicious code or defects when sent.  This message and its
attachments could have been infected during transmission.  By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action regarding the 
code
or such defects.  The sender is not liable for any loss or damage arising 
in
any way from this message or its attachments."

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


"The sender believes that this E-mail and any attachments were free of any
harmful and malicious code or defects when sent.  This message and its
attachments could have been infected during transmission.  By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action regarding the code
or such defects.  The sender is not liable for any loss or damage arising in
any way from this message or its attachments."

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users