Cell Formatting
jamex wrote:
I think no such format is available to restrict a cell to accept only
7 alphabets, but validation can restrict it:
Data-Validation
Allow=Text length
Data=Equal to
length=7
click ok
Now just type any seven alphabets in your active cell.
Cheers...Jamex
The requirement was for digits not alpha-numeric.
|