| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 & _ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format Returned Values in VBA Q
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 & _ -- Rick (MVP - Excel) "Seanie" wrote in message ... 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 & _ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format Returned Values in VBA Q
Thanks, that simple..
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup multiple values - sum returned values into single cell | Excel Worksheet Functions | |||
| Getting a list of returned values from an array | Excel Worksheet Functions | |||
| How do I sum values returned from functions? | Excel Worksheet Functions | |||
| Conditional Format on returned value | Excel Programming | |||
| How do I set up a conditional format using the value returned by . | Excel Discussion (Misc queries) | |||
Linear Mode
