SET DECIMALS TO 2 lnvalue = 2.61 ?IIF(RIGHT(ALLTRIM(transform(lnvalue,"9,999,999.99")),1)>"0",ALLTRIM(TRANSFORM(lnvalue,"9,999,999.99")),IIF(RIGHT(ALLTRIM(transform(lnvalue,"9,999,999.9")),1)>"0",ALLTRIM(transform(lnvalue,"9,999,999.9")),ALLTRIM(transform(lnvalue,"9,999,999")))) lnvalue = 2.60 ?IIF(RIGHT(ALLTRIM(transform(lnvalue,"9,999,999.99")),1)>"0",ALLTRIM(TRANSFORM(lnvalue,"9,999,999.99")),IIF(RIGHT(ALLTRIM(transform(lnvalue,"9,999,999.9")),1)>"0",ALLTRIM(transform(lnvalue,"9,999,999.9")),ALLTRIM(transform(lnvalue,"9,999,999")))) lnvalue = 2.00 ?IIF(RIGHT(ALLTRIM(transform(lnvalue,"9,999,999.99")),1)>"0",ALLTRIM(TRANSFORM(lnvalue,"9,999,999.99")),IIF(RIGHT(ALLTRIM(transform(lnvalue,"9,999,999.9")),1)>"0",ALLTRIM(transform(lnvalue,"9,999,999.9")),ALLTRIM(transform(lnvalue,"9,999,999"))))I can't think of any other way, but maybe someone else can.