In article , CLR
writes
Put this in D1 and copy down........

=IF(C1="","",IF(ISNUMBER(C1),3,4))


Vaya con Dios,
Chuck, CABGx3



Hi

Me again

Suddenly , I find this doesn't work. I did test it out before , and it
seemed to work fine. Now , I'm trying it again in my workbook. It should
return 3 for cells with all numbers , and 4 for cells with numbers and
letters combined. However , it just returns 4 for everything.

This is what I'm using :


=IF(H2="","",IF(ISNUMBER(H2),3,4))


Curiously , if I do a simple test in a blank wb with just a few cells
containing numbers and letters , it works. When I run it in my larger wb
, it doesn't!

Can you advise?

Thanks.



"Colin Hayes" wrote:


HI

In column C I have a list of reference numbers.

Some of these reference numbers only contain numbers and some contain
numbers and letters.

In column D I need to put a number 3 three for those cells in C which
contain just numbers , and 4 for those cells which contain combined
numbers and letters.

Can some one help with some code for this , please?

Any help appreciated.

Best Wishes