(FORMAT(.CurrColumn,'[-]999,999,990')) Dennis McGrath
________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Friday, April 17, 2009 9:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Formatting currency without cents. I'm writing a form on which I want to display a bunch of currency figures (aged payables and receivables) without the dollar sign or any decimals. That is $421,187.16 should display as 421,187 with no decimal. I'm retrieving the values with SELECT and placing them into static text labels using PROPERTY CAPTION. . . I figured the easiest way would be to change the CURRENCY setting to have no decimals (SET CURR ' ' PREF 0 B), but this has the effect of retrieving the whole number and shifting the decimal to places, multiplying all the numbers by 100. So far, the best I can find is (ROUND(FLOAT(CurrColumn, 0))). Has anyone done this before? -- Larry
