Re: How can SQR generate an excel file with numeric data being displayed as a string?

[Arjan Hoornstra <ahoor@YAHOO.COM>]

I think that when you put double-qoutes around the number it forces
Excell to treat it as text.... "123456789012"
Do not use single quotes as they may be treated different and cause
prblems in the sqr script.

Arjan

--- Emil Galicinao <e.galicinao@MOTOROLA.COM> wrote:
> Hi Everyone,
>
> Does anybody know how to convert a numeric data into a string such
> that
> when I generate the report in excel, that data will no longer be
> treated
> as numeric?  Right now, when a  numeric data is more than 11 digits
> long, excel usually convert the data into an exponential form which
> is
> something Im trying to avoid.
>
> An example would be:
> The number 123456789012 becomes 1.23457E+11 when viewed from excel.
>
> I was thinking of appending a special character on that numeric data
> but
> unfortunately, that special charater also appear in the report.
>
> Any suggestions?
>
> Best Regards,
> Emil


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/