Format Returned Values in VBA Q

S

Seanie

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 & _
 
R

Rick Rothstein

When you use Range(xx) without specifying a property, the Value property is
assumed. Try using the Text property instead...

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