Thanks, Tom! This worked perfectly. Sue
On Apr 2, 2007, at 12:11 PM, Tom Elliott wrote:
Let ([ dollars = Int (currentpayfield) ;
cents = Round (currentpayfield - dollars ; 2) ;
centsAsText = Left (100 * cents & "00" ; 2)
] ;
"$" & dollars & "." & centsAsText
)
