[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[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