+ Reply to Thread
Results 1 to 2 of 2

[SOLVED] remove percent symbol on percentage formatted cells in excel

  1. #1
    IncognitoPC
    Guest

    [SOLVED] remove percent symbol on percentage formatted cells in excel

    Hello,

    I'm trying to get a cell to have a percent format but not display the
    percent symbol "%".

    How can I do that? if at all.



  2. #2
    Dave O
    Guest

    Re: remove percent symbol on percentage formatted cells in excel

    It can surely be done, at the risk of confusing people who don't know
    what they're looking at. In whatever percentage calculation you have,
    multiply the result by 100, or at the end of the calculation add "*100"
    ( star one zero zero without the quotes).


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1