How do you format a cell to read text only?

  • Thread starter Thread starter kjb22
  • Start date Start date
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers change in cell even when formatted as text 4
Entering a Text Symbol ? 2
Excel Conditional Formatting 1
protect cell format 1
Text in Cell Formatting 5
Custom Number Format for text 8
Excel - convert dates to text but appear as a date format 6
Text in Text-formatted cells changes to ### after the 255th charac 2

Back
Top