Formatting of a number
| From: | Scott Parks | Date: | Wed, 16 Nov 2005 20:34:50 +0000 |
| Subject: | Formatting of a number | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-225931@lists.php.net to get a copy of this message | ||
Hi-
I have a number that I am trying to format. It is data coming from a main frame and
has 8 characters assigned to it (6 and two decimal places). I have zerofill set up in
MySQL on this field and am working on the best way to display the number.
Currently I have this:
$sOutput = number_format(rtrim($sValue,'0') /100,2);
What I am running into is this, I have a number in this field as:
3145900, using the above I will get: 314.59, which is wrong, it
needs to be 3,145.90.
Yet, if I have a number of: 749450, I get the result I am looking for
of 749.45.
I did not see a way to tell trim I only want one 0 cut?
Any thoughts?
Thank you!
-Scott