Formatting a text statement

  • Thread starter Thread starter DaveMoore
  • Start date Start date
D

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
 
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
 
Back
Top