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

[Emil Galicinao <e.galicinao@MOTOROLA.COM>]

Hi Rod, Arjan,

Enclosing a numeric data by a double quote works !!!
BTW, I tried using the second option but I was not able to get the same output
as in option 1. (maybe it depends on the excel version)
Any way,  Thanks for the options/suggestions.

Best Regards,
Emil

Rod Wright wrote:

> You can get around this in two ways. The first is to place =" in front of
> the number and " at the end of the number. So, 1234567890123 becomes
> ="1234567890123". Excel will then treat this as text. This method is
> particularly useful if you want to retain leading zeroes. (By the way, they
> are double quotes.)
>
> The second method is to leave the number as is, and widen the column in
> Excel. My experience has been that Excel switches to scientific notation
> when the column is not wide enough to display the number.
>
> HTH,
> Rod
>
> Emil Galicinao <e.galicinao@MOTOROLA.COM>@list.iex.net> on 06/29/2001
> 06:27:01 AM
>
> Please respond to sqr-users@list.iex.net
>
> Sent by:  "Discussion of SQR,              Brio Technology's database
>       reporting language"              <SQR-USERS@list.iex.net>
>
> To:   SQR-USERS@list.iex.net
> cc:
>
> Subject:  How can SQR generate an excel file with numeric data being
>       displayed as  a string?
>
> 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