RE: [sqr-users] Formatting a number with decimals

[James Womeldorf <jwomeldo@fastenal.com>]

Maria,
If you really want to format an Excel file using SQR take a look at this:
http://www.ontko.com/sqr/sylk.html
Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On Behalf Of
Lindquist, Maria
Sent: Thursday, October 21, 2004 1:51 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: [sqr-users] Formatting a number with decimals


I'm trying to format a number that is written out to a file that is
opened up in Excel. When I do the follwoing string:
 
string $CliAcctNum $LastName $FirstName $Address1 $City1 $State1
$Postal1 
        $SSN  $Phone $Balance $Address2 $City2 $State2 $Postal2 by
$Format into $Output_Row

I want it to include zeros after the decimal point for the variable
$Balance if it is an even number. I have tried Let $Balance =
edit($Balance,'99,999.99') but it still is not bringing in the zeros
after the decimal point. If there are other numbers after the decimal
point it brings in those, but not if it is just zero. Is this possible
at all? Or do I need to tell the user that they will just have to do the
Format Cell thing after running this file to excel?
 
Any suggestions would be greatly appreciated.
 
Thanks!
 
________________________________

Maria K Lindquist
mlindqui@uwc.edu <mailto:mlindqui@uwc.edu> 
IS Programmer/Analyst - Business Office
University of Wisconsin Colleges
780 Regent St, PO Box 8680, Madison, WI  53708-8680
Phone: 608.265.2677 / Fax: 608.265.5770
 <http://www.uwc.edu/images/logo_large.gif> 
 

_______________________________________________
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