View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

Select the cell & press Ctrl-1
Navigate to the Number tab
Select Custom in the left hand panel
In the Type edit box enter 0.00"%"
Click on OK

"sweetsue516" wrote:

How do I add the % sign to a existing number without changing the value?
Example: 1.68 should show 1.68% not 168?