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



R1dgeway wrote:

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