A better way is a computed integer column = (INT(mydollars*100)) Dennis McGrath [email protected] [email protected]
On Sun, Feb 23, 2014 at 6:37 PM, Buddy Walker <[email protected]>wrote: > Ned > I would set the value to text and then replace the decimal point with > nothing. > > Buddy > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Ned > Ritchie > Sent: Sunday, February 23, 2014 7:11 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - NO DECIMAL POINT > > I'm still in older DOS and upgrading to Windows. . . > > Medicare will be requiring NO DECIMAL POINT on dollar amounts on printed > paper forms. > Example: > 123.45 must become 12345 > > The Report Picture Format in DOS > [>]9999.00 gives 123.45 > The following Picture Formats just truncate the cents: > [>]999999 > [>]999900 > 999999 > 999900 > 000000 > > Any suggestions or workarounds? > > 2nd question: > How would one do it in Windows 7.6? > > Thank you, > Ned Ritchie > Judy's Intimate Apparel > > >
