Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to format a cell as percentage with two decimals. I used format cell and keep the decimal places as 2. But I want to restrict the full numbers to two.

Ex:23.45%

Then I used a custom format like

00.00%

But I couldn't restrict the entering more than two numbers before decimal place.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Perhaps the simplest way to do this would be to use data validation. In the Data tab select data validation then in the settings tab set the type to decimal and restrict to between 0 and 1. If you then set the cell type to percentage then values will be represented in the format you want.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.