[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Retain leading zeros's for .xls output from SQR
- Subject: [sqr-users] Retain leading zeros's for .xls output from SQR
- From: Gowri Srinivas <gow_srinivas@yahoo.com>
- Date: Fri, 26 Aug 2005 15:46:34 -0700 (PDT)
- Delivery-date: Fri, 26 Aug 2005 17:47:41 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=FMVtaL7cuBuvhytsbxtg/BKK1x5cXczJgj/iadxIJeKRDnC03fHCvdeS5mY40FuFAPGNw43WAVE0ScO/AxAptl1VgMiz88NcCxVAMZRAfJuUHRsn0R8QYmmKfisP686nxZS0fWu246gQ632q1Qbj4d3UkFo7U+Izfzy6Hd/3zN0=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi All,
I would like to know how I can retain the leading zeros (Egs. Invoice =
'000000005') in the excel output from SQR. The leading 0s are truncating as
excel treats the string as a number.
Thanks in advance for your response.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users