Formatting a text statement

[DaveMoore]

The formula below gives me the result I want but can the money element
be formatted to show the '000 separator?

="Reducing balance difference at "&$A$1&" is £"&D296

Where cell D296 is a figure; how can I format the result to be
#,##0.00

Many Thanks

 

[Gord Dibben]

Assuming a date and money element.

="Reducing balance difference at "&TEXT($A$1,"mm/dd/yyyy" )&" is " &
TEXT(D296,"£#,##0.00")


Gord Dibben MS Excel MVP