Thread: Percentage sign
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brian thompson3001 via OfficeKB.com brian thompson3001 via OfficeKB.com is offline
external usenet poster
 
Posts: 13
Default Percentage sign

Hi

I am using the below code that I got off this forum. All works to my
requirements, except, in cell L31 on all of my sheets in the workbook shows
the value as a percentage, e.g. 31.16%
When runing the macro, I get the value in the summary sheet as 0.311615
Q. What alteration is required to the code and where abouts it be placed to
show the correct format?
I am not a code writer, nor understand them and only get by with copy and
paste, and therefore any help would be appriciated

thanks in advance

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200612/1