General discussion

Locked

Entering percentage's in Excel 2000

By cpapachristou ·
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%.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Entering percentage's in Excel 2000

by Ann777 In reply to Entering percentage's in ...

To get it to say 8.25%, input .0825

Collapse -

Entering percentage's in Excel 2000

by cpapachristou In reply to Entering percentage's in ...

Poster rated this answer

Collapse -

Entering percentage's in Excel 2000

by DKlippert In reply to Entering percentage's in ...

Tools>Options>Edit>Enable Automatic Percent Entry

This will do what you want in those cells formatted as %

Collapse -

Entering percentage's in Excel 2000

by cpapachristou In reply to Entering percentage's in ...
Collapse -

Entering percentage's in Excel 2000

by brian In reply to Entering percentage's in ...

Or enter the decimal equivilant.
8.25%=.0825

Collapse -

Entering percentage's in Excel 2000

by cpapachristou In reply to Entering percentage's in ...

Poster rated this answer

Collapse -

Entering percentage's in Excel 2000

by cpapachristou In reply to Entering percentage's in ...

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums