Results 1 to 2 of 2

Thread: Display % sign

  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Seattle, WA - USA
    Posts
    21
    Thanks
    17
    Thanked 0 Times in 0 Posts

    Display % sign

    Hello,

    Am usng Excel 2010.

    Colum E5:6 displays the percentage of C4.
    -
    Is it possible to have 52% and 48% displayed in column E?

    Thanks,
    Albert
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Albert,

    Just drop the *100 in e4&5 then format as % with 0 decimal places.
    Attached Files Attached Files
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    abaas (2011-11-30)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •