Input Mask

D

dukealberto

Hello,
I've this problem; I need to have an input mask like this:
- length max = 5
- format = number-number, where number go from 01 to 99

Thanks to all.

Albert
 
J

Jason Morin

How can an entry be more than 2 digits if it has to be a
number from 1 - 99 in ## format? No need for max length =
5. Go to Data > Validation, choose "Custom" under Allow,
and use:

=AND(A1>=1,A1<=99,LEN(A1)=2)

and format the cell as Number with 0 decimals.

HTH
Jason
Atlanta, GA
 
Top