EXCEL CELL PROTECTION

P

PRASAD

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
 
N

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
[email protected]
 
Top