On Apr 10, 2007, at 17:52 UTC, Carlos M wrote: > This code > Format(1234567.123, "#,###.##") > displays "1,234567.12"
Wow, it does! Not a bug I've seen before. We should have a ROTOR test for it... > Shouldn't it be "1234,567.12"? No, it should be "1,234,567.12". (In the Format specifier, it doesn't matter how many commas you put in or where you put them; the mere presence of a comma indicates that you want to use the thousands separator in the standard way, i.e. every 3 digits.) > And this code > Format(1234567.123, "####,###.##") > displays "1,234,567.12" > > Shouldn't it be "1234,567.12"? No, this one is correct. Weird. Also producing correct results is the simpler (and equivalent) format specifier, "#,.##". Only the first example you gave above is producing wrong results. So it's easy to work around (just use the simple specifier), but still should be fixed. Best, - Joe -- Joe Strout -- [EMAIL PROTECTED] Verified Express, LLC "Making the Internet a Better Place" http://www.verex.com/ _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
