>hi, Transform(-7819,'@ZB9,999,999.99') seems cannot work. Empty spaces within the parentheses still appear. thanks

Are you sure that you have no typo? Be sure to write it EXACTLY as I did, no spaces in the function!

If you still don't get what you want, please tell what you see, and what you want to see!