RE: [sqr-users] SQR output in .csv file

["Jim Womeldorf" <jwomeldo@fastenal.com>]

Srikanth,

If you really want to format the output of an Excel file created using
SQR take a look at the stuff at this link
http://www.ontko.com/sqr/sylk.html.
It takes more work than just producing a CSV or character delimited file
but you will be able to produce Excel files with quite a bit of
formatting.

Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of
srikanth reddy
Sent: Monday, September 05, 2005 9:40 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR output in .csv file 

Hello ,
  I am having a two issues while displaying values in the .csv format .
 
(i) if the Output I want to display is 3,456.234 then in the Excel file
3 is being displayed in one column and 456.234 is being displayed in
another column.
Point to be noted is I have used the technique like '=" || xyz || '"'
where xyz contains the value but still the output is splitted into two
different coulmns in the excel file.
 
(ii) if the output i want to display is 23.450 then only 23.45 is
displayed in the Excel file. i.e. trailing zero is not displayed.
 
Can you please suggest a solution for this.
 
Thanks
Srikanth


                
---------------------------------
 Click here to donate to the Hurricane Katrina relief effort.

_______________________________________________
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