How about:
If IsNumeric(cell.value) Then
rather than putzing with cell formatting?

--
George Nicholson

Remove 'Junk' from return address.


"Chris" wrote in message
...
I need to find the format type of a cell in excel. I have an IF statement
that will take a numeric number and apply it to a range to see if it falls
into the range or outside of the range but when the cell has a text value
it
bombs on me.

I need to validate which format it has before I apply the condition.

Thanks for you help,

-Chris