# Thread: Percentage format (Excel 2002)

1. ## 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

2. ## 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. ## 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 %.

4. ## 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. ## Re: Percentage format (Excel 2002)

Hi Andrew

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