How to use Text functions?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Does anyone have any suggestions on how to use Text function?
I would like to display the number in percentage%
2% Foods
=text(0.02, format)&"Foods
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 
try this

cell A1 has value then in B1 put this formula

=TEXT(A1,(A1*100))&" % Foods"
 
If you want to format the number to percentage to where this number is alone
in this cell (with no text), then you use:

Select the cells where the values are > Format > Cells > Percentage >
[adjust decimal paces] > OK


If there is text, then you would use:

Assuming A1 has the percentage value say 25%

="Our profit has increased for "&TEXT(A1,"0%") & " since last June"

This should show "Our profit has increased for 25% since last June"


--
HTP
Adnan

If I have helped and/or answered your question, please let me know by
replying or clicking question answered (below positioned ‘Yes’ button).
 
Back
Top