Posted by Scott Parks on 11/16/05 22:34

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

• Next in forum: Re: [PHP] Formatting of a number
• Prev in forum: Re: [PHP] better way to mix html and php code?
• Thread view: Formatting of a number

[Reply to this message]