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
-----Original Message-----
Hi,

I've done this before but i've forgotten how!

How do I determine whether or not a cell contains a
number ?

Excel97

TIA

regards
Don Lloyd

--



.