View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seanie Seanie is offline
external usenet poster
 
Posts: 202
Default Format Returned Values in VBA Q

The code below returns for me the values in Cells E6 & B62, but the
value in B62 is 18.87% but what is returned for me on my code is
0.1847547857. How can I format what is returned as **.**%?


ThisWorkbook.Sheets("Master").Range("E6") & " " & ThisWorkbook.Sheets
("Report").Range("B62") & vbNewLine & _