LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 47
Default Show decimal as percent

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivottable: Show value as a percent of Subtotal Ted M H Excel Discussion (Misc queries) 10 May 10th 08 04:57 AM
Show Percent changes christen Charts and Charting in Excel 1 April 25th 07 03:50 PM
How do you show percent changes with color shading? Manesa Charts and Charting in Excel 1 December 22nd 06 07:30 PM
How do you show percent changes? Manesa Charts and Charting in Excel 0 December 22nd 06 07:01 PM
How to calculate and then show up as a percent? Amuse Excel Worksheet Functions 1 July 10th 05 10:19 PM


All times are GMT +1. The time now is 08:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"