Prasad

First, upper case in posts is like shouting and considered rude.

While in A1, go to DataValidationAllow dropdown, 'custom' and type a
formula of...

=ISTEXT(A1)

You can highlight your cells first and then type the reference to the
activecell. The rest will update automatically
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"PRASAD" wrote in message
...
I WANT TO ENTER ONLY TEXT IN EXCEL CELL NOT NUMBER
I WANT TO PROTECT THE CELL FROM NUMBER NOT FROM TEXT

IS IT POSSIBLE

PLEASE GIVE ME SOLUTION

FROM

PRASAD