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