Formating formulas in text strings

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

I am trying to write a piece of text in excel and within
the text have references to cells on a stats sheet.
I have been able to that but I am unable to format the
value.

For example:
="Total Spend in FY04 is $"&'Sub Select Stats'!F10&""
which appears like this
Total Spend in FY04 is $11878420.87
I would like to make this easier to read by applying the
US Dollar Currency Format.
Is this possible as the value is part of a text string.



I would also like to format % values as they are
appearing as
"% value is 0.0534351145038168"


Appreciate your help.
 
Try

="Total Spend in FY04 is "&TEXT('Sub Select Stats'!F10,"$#,##0.00")

no need for the extra &""
 
Back
Top