EXCEL CELL PROTECTION

[Guest]

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

 

[Nick Hodge]

Prasad

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

While in A1, go to Data>Validation>Allow 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
(e-mail address removed)