Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Percentage format (Excel 2002)

    Hi

    When you format a cell to percentage Excel automaticaly multiplys the cell by 100 , is there a way to format itso that you can enter 10 instead of 0.10 this is a simpe example I know.

    But this spreadsheet goes out to other users using a whole range of percentages.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Percentage format (Excel 2002)

    Once you format the cell to percent, you should be able to enter 10 and it will add the percent and automatically enter "0.10" as the value.

    Note: The formatting does not affect the value in the cell only the display and a comment: excel does not multiply by 100. The cell contains the 0.10, the display shows 10%. If formatted to percent and 10 is entered, excel will add the "%" and the value you enter is automatically "divided by 100" to yield 0.10 as the value. The % is shorthand for "divided by 100" (which is what "per cent" means). 10% = 10/100 = 0.10

    Steve

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percentage format (Excel 2002)

    That would not be a wise thing to do. If someone sees a cell that displays 10%, he would expect to be able to multiply that cell by another cell and get an answer that is 10% of that cell. Doing what you say (yes, it can be done with a custom format), could lead to someone making some very bad decisions. It would be much better to divided the cells by 100 and then format them to a real %.
    Legare Coleman

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Percentage format (Excel 2002)

    If you goto Tools, Options and select the Edit tab, you can set Enable automatic percent entry. To quote from the 'What's this' help :
    <hr>Select to multiply by 100 all numbers less than 1 that you enter in cells formatted in the Percentage format. Clear this check box to multiply by 100 all numbers that you enter in cells formatted in the Percentage format, including numbers equal to or greater than 1.<hr>
    Andrew C

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Percentage format (Excel 2002)

    Hi Andrew

    Thanks for the response, and thanks to all who responded.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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