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 &""
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart help 2
Macro to add numbers in a text string 5
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
LARGE to corresponding text value 1
Custom Number Format for text 8
Numbers change in cell even when formatted as text 4
Conditional formatting for time 1
Date Format 2

Back
Top