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

["Knapp, Richard" <KnappR@umsystem.edu>]

I'll bet the zeros are there in the SQR environment but Excel is
dropping them (more or less famous for this).

 
Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@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
fromHyperion 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