percentage
Use Peo's suggestion of:
=TEXT(TRUNC(your_formula/100,4),"0.00%")
Sort of like this:
="We have a success rate of "&TEXT(TRUNC(your_formula/100,4),"0.00%")
--
Biff
Microsoft Excel MVP
"ekkeindoha" wrote in message
...
Sorry for the confussion.What I meant with the & & & feature are when you
want to form a sentance
"Peo Sjoblom" wrote:
Doh! the division will take care of the number conversion.
=TRUNC(your_formula/100,4)
or maybe even
=TEXT(TRUNC(your_formula/100,4),"0.00%")
if you want a text value
--
Regards,
Peo Sjoblom
"Peo Sjoblom" wrote in message
...
=TRUNC(--(your_formula/100),4)
is probably better
--
Regards,
Peo Sjoblom
"Peo Sjoblom" wrote in message
...
=--TRUNC(your_formula/100,4)
and format as percentage
--
Regards,
Peo Sjoblom
"ekkeindoha" wrote in message
...
Good day,
I need to know how I can enter a percentage from a total into a line
by
using the & & & & & & feature.The problem i've got is that it gives
me
93.5676458748534563
and all I need are 93.56 %.
Rgds
Jules
|