How do you format a cell to read text only?
 

How do you format a cell to read text only?
 

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

But maybe DataValidationAllowCustom =ISTEXT(A1) or whichever cell(s)
you need limited to text-only entry.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 15:19:00 -0700, kjb22
wrote:

How do you format a cell to read text only?
 

Hi Gord:

I am trying to limit certain columns to text only entry. In
datavalidationallowcustom 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" wrote:

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

But maybe DataValidationAllowCustom =ISTEXT(A1) or whichever cell(s)
you need limited to text-only entry.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 15:19:00 -0700, kjb22
wrote:

How do you format a cell to read text only?
 

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

On Wed, 17 Sep 2008 10:45:01 -0700, kjb22
wrote:

Hi Gord:

I am trying to limit certain columns to text only entry. In
datavalidationallowcustom 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" wrote:

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

But maybe DataValidationAllowCustom =ISTEXT(A1) or whichever cell(s)
you need limited to text-only entry.


Gord Dibben MS Excel MVP

On Tue, 16 Sep 2008 15:19:00 -0700, kjb22
wrote: