Thread: percentage
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ekkeindoha ekkeindoha is offline
external usenet poster
 
Posts: 46
Default 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