No-numeric data

[Rob Barnard]

I haven't used Excel 97 for some time but this works in
2000 - might be worth a try for you:

=ISNUMBER(<cell reference>)

This returns either a TRUE or FALSE

Rob

 

[Donald Lloyd]

Thanks Rob, I was trying ISNUMERIC

--

I haven't used Excel 97 for some time but this works in
2000 - might be worth a try for you:

=ISNUMBER(<cell reference>)

This returns either a TRUE or FALSE

Rob