ExcelBanter - No-numeric data

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - No-numeric data (https://www.excelbanter.com/excel-programming/272813-no-numeric-data.html)

Rob Barnard

No-numeric data

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

--

.

Donald Lloyd

No-numeric data

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

--

.

All times are GMT +1. The time now is 07:16 PM.