Format cells option for a cell in an excel

[Nikhil2803]

I have a column as ZIP code based out of USA that can have maximum length as 5. If I give 11, then it can take 000 as predecessors and become 00011. I tried formatting cells option but that has options to make it 0011 or 000-11 or 000000011. I am not getting options to make 00011.

Any leads on this will be highly appreciated. Thank you.

 

[RoryA]

Use a custom format of 00000

 

[Nikhil2803]

Use a custom format of 00000

Thank you. It is working now. Can you also help me if user can be restricted to provide length higher than 5. If he gives 123456, he/she should get an error that max length is 5. I can not do data validations as I have write some other validations there.

 

[RoryA]

What kind of validation do you have currently? Can you not add this one in?

 

[Nikhil2803]

What kind of validation do you have currently? Can you not add this one in?

I am checking if a different cell contains values or not. I can not add multiple data validations for a cell.

 

[RoryA]

How are you checking that? If using a formula, you can simply add another test.