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"



On Nov 12, 11:33*am, Eric wrote:
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

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).


"Eric" wrote:

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