|
percentage
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 |
percentage
Not sure what you're asking...
A1 = 93.5676458748534563 =TRUNC(A1/100,4) Format as PERCENTAGE Returns 93.56% -- Biff Microsoft Excel MVP "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 |
percentage
I have no Idea what you mean by the "& & & & & & feature"
have you tryed formating it as a Percent "ekkeindoha" wrote: 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 |
percentage
=--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 |
percentage
=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 |
percentage
Maybe concatenation like =A2&B2 etc
-- Regards, Peo Sjoblom "bj" wrote in message ... I have no Idea what you mean by the "& & & & & & feature" have you tryed formating it as a Percent "ekkeindoha" wrote: 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 |
percentage
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 |
percentage
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 |
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 |
percentage
thx for the info, it works 100%
"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 |
| All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com