Entering percentage's in Excel 2000
I have classified a cell as a percent with 2 decimal places. Every time I enter a number such as 8.25 it changes it to 825.00%. The percent is
fine but, how do you get it say 8.25%.
Software
I have classified a cell as a percent with 2 decimal places. Every time I enter a number such as 8.25 it changes it to 825.00%. The percent is
fine but, how do you get it say 8.25%.
by ann777
To get it to say 8.25%, input .0825
by dklippert
Tools>Options>Edit>Enable Automatic Percent Entry
This will do what you want in those cells formatted as %
by brian
Or enter the decimal equivilant.
8.25%=.0825
This discussion is closed to new replies.
Sort by Trending