1. Finish the formula with

"P1C1ARNU" & "=" & Format(LP1C1ARNU, "0.0%")

2. For a new line, include the character vbNewLine:

.... & vbNewLine & "P1C1ARNU" & "=" & LP1C1ARNU

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Gizmo" wrote in message
...
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.