Using the Allow: Text length
seems to not exclude numbers,
although the use of the word text
suggests so,,

Jim

"jamex" wrote in
message ...

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


--
jamex
------------------------------------------------------------------------
jamex's Profile:
http://www.excelforum.com/member.php...o&userid=32243
View this thread: http://www.excelforum.com/showthread...hreadid=521479