help in formula

  • Thread starter Thread starter Junaid
  • Start date Start date
J

Junaid

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.
 
Junaid said:
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.
Click to expand...

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

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