How specify number format of cell value in concatenate function?

R

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.
 
D

Dave Peterson

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