A similar question has been asked about doing this in beast mode, and a rather lenghty solution was proposed.
However, I'm wondering if anyone has formatted numeric values prior to including them in a beast mode concat, either via workbench or ETL/SQL?