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"
|