Thread: Cell Formatting
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Paul Lautman
 
Posts: n/a
Default 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.