How specify number format of cell value in concatenate function?

[R1dgeway]

When combining text and cell values in a concatenate function, I would like
to control the number format in the concatenate cell: comma separator,
decimal place, etc.

 

[Dave Peterson]

="this is text " & text(a1,"$000,000.00") & " due on: " & text(b1,"mm/dd/yyyy")