G gill Feb 27, 2004 #1 I want to be abel to ensure a cell contains only letters of the alphabet and not numbers -is there any way to do this please?
I want to be abel to ensure a cell contains only letters of the alphabet and not numbers -is there any way to do this please?
P Peo Sjoblom Feb 27, 2004 #2 Assuming you meant that the whole string must be letter only like abcd and not ab2cd do data>validation>custom and use this formula =ISNA(MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0)) that will prevent people entering numbers in strings in cell A1 (adapt to fit) If you meant only one number or one letter k but not 5 the above works as well but then you could use a simpler formula =NOT(ISNUMBER(A1))
Assuming you meant that the whole string must be letter only like abcd and not ab2cd do data>validation>custom and use this formula =ISNA(MATCH(TRUE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0)) that will prevent people entering numbers in strings in cell A1 (adapt to fit) If you meant only one number or one letter k but not 5 the above works as well but then you could use a simpler formula =NOT(ISNUMBER(A1))
G gaftalik Feb 27, 2004 #3 Hi Gill , Select the cell or range of cells you want , choose data from your menwrite =istext("your selected cell or range of cells" ) and then clic ok . P.S : in Error tab under error message you may write what you want a an message when you edit numbers in your selected cells by mistake Good luck ! Gaftalik
Hi Gill , Select the cell or range of cells you want , choose data from your menwrite =istext("your selected cell or range of cells" ) and then clic ok . P.S : in Error tab under error message you may write what you want a an message when you edit numbers in your selected cells by mistake Good luck ! Gaftalik
K Ken Wright Feb 27, 2004 #4 This will still allow 'numbers in text' if the title is taken literally, as abc2def is a text value. Peo's solution however, would prevent this.
This will still allow 'numbers in text' if the title is taken literally, as abc2def is a text value. Peo's solution however, would prevent this.
