Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel2003
I am using the following code to add a record to my collection page. Dim LP1C1ARNU As Double .... .... Range("D" & LRow - 1).Value = LComments1 & " " & LRun & " " & "P1C1AR" & "=" & LP1C1AR & " " & "P1C1ARNU" & "=" & LP1C1ARNU LP1C1ARNU is from another page in percent format, but shows up in the new cell as a Decimal.(ex P1C1ARNU=.157) How can I show it as Percentage?(ex P1C1ARNU=15.7%) I would also like to know how to add "alt enter" to the expression so I can line up the values in the cell. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivottable: Show value as a percent of Subtotal | Excel Discussion (Misc queries) | |||
Show Percent changes | Charts and Charting in Excel | |||
How do you show percent changes with color shading? | Charts and Charting in Excel | |||
How do you show percent changes? | Charts and Charting in Excel | |||
How to calculate and then show up as a percent? | Excel Worksheet Functions |