Thanks Rob, I was trying ISNUMERIC

--

"Rob Barnard" wrote in message
...
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

--



.