View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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: