>>>>The source cursor was created via

>>>>select dist fundtype, ;
>>>>	cast(000000000000.00 as N(15,2) NULL) as priorpmt,;
>>>>	cast(0000000000 as I NULL) as thisyear, ;
>>>>	cast(0000000000.00 as N(13,2) NULL)as spent, ;
>>>>	cast(0000000000.00 as N(13,2) NULL) as currentbalance, ;
>>>>	cast(0000000000 as I NULL) as futureprogram, ;
>>>>	cast(0000000000.00 as N(13,2) NULL) as total ;
>>>>	from tipdatabase!fundtypes ;
>>>>	order by fundtype ;
>>>>	into cursor crsTemp readwrite

so the datatype for thisyear is integer although there are also number fields I will have to deal with in similar fashion. I think my second sample was taken directly from the site shown in your link.
>>>
>>>If the ThisYear is Integer, why do you want to display it in the money format? May be you wanted another field, say, Spent ?
>>
>>The entire table is money. Budgets are kept in whole dollars hence integer for efficiency. Expenses however carry the pennies hence a decimal value.
>
>Anyway, cast everything to N(13,2) or to Currency. Does the formatting code above work for Numeric fields?
No it does not.