Thread: percentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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