"Scott Parks" <scottaparks@xxxxxxxxx> wrote in message news:95ECBB2B-8A48-4D28-A381-A1450C394D4B@xxxxxxxxxxxx > 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? Just convert the string into a number, and work with it as a number: // first, convert the string into a number (assuming 3 decimals, as your example shows) $nValue = floatval($sValue) / 1000; // then, format it $sOutput = number_format($nNumber, 2); DanB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
