Thread: help in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe User[_2_] Joe User[_2_] is offline
external usenet poster
 
Posts: 905
Default help in formula

"Junaid" wrote:
I have given a formula that gives the specific
cell data into the text i.e ="text "&AB4&" text"
now my problem is that AB4 is the percentage
it gives me 7 or 8 digits after the point but don't
need any digit after or maximum 2.


I'm not exactly sure what you want, but I hope you can make use of the
following:

="text " & TEXT(AB4,"0.00%") & " text"