No-numeric data

  • Thread starter Thread starter Rob Barnard
  • Start date Start date
R

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
 
Thanks Rob, I was trying ISNUMERIC

--

Rob Barnard said:
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
Click to expand...
 
Back
Top