# ISNUMBER returning FALSE

From Rockcliffe Library Network

## Problem

ISNUMBER is returning FALSE when provided with a formula that references a cell containing a number. For example,

In cell A1 I have a string "AA42"

In cell B1 I have the number '42' as the result of a formula =RIGHT(A1,2)

In cell C1 I have the formula =ISNUMBER(B1) however this formula is returning FALSE

## Solution

ISNUMBER is expecting a value. As the original value was text, even though the cell format might be set to 'General', excel needs to be told explicitly that what it is trying to evaluate is a number.

To correct the formula use the following:

=ISNUMBER(VALUE(B1))