I think it easier to do format( '%.2f', [trunc(value*100)/100]); Notice: This email and any attachments are confidential. If received in error please destroy and immediately notify us. Do not copy or disclose the contents.