View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default how to get the percentage symbol with the result?

how to get the percentage symbol with the result?
i have a farmula to calculate the percentage. i want to get the
result with the percentage sign.It should be something like this.
D2=540 E2=600
F2=PERCENTAGE(D2/E2*100)%
thanks.


Format F2 in the % style;
Change your formula to...

=D2/E2

...and that's it!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion