How do you format a cell to read text only?

[Gord Dibben]

Please provide more detail using the large white section called the "body"
as I am doing.

But maybe Data>Validation>Allow>Custom =ISTEXT(A1) or whichever cell(s)
you need limited to text-only entry.


Gord Dibben MS Excel MVP

 

[kjb22]

Hi Gord:

I am trying to limit certain columns to text only entry. In
data>validation>allow>custom I entered =ISTEXT(B9:B50), but I still get my
stop message when entering any letters only. I am doing something wrong, but
can't figure it out.

Thanks for your help.

 

[Gord Dibben]

You cannot do that on a range.

Select B9:B50 and enter the formula =ISTEXT(B9)

Make sure you enter as above. Don't let Excel add any $ signs


Gord Dibben MS Excel MVP