scrabtree wrote:

Number 2: Cell one has a social security number in it and
is special formatted as social security number. Cell two
has the same value in it but is formatted general. An if
statement compares those two cells and says they are not
equal. I want it to say they are equal???

A hint: change both the cell's format to "General".
That will give you some hint why they are not equal.
Then change back to the format social security, and then to the
user-defined format (don't know the name in English, in Dutch it's
"Aangepast", the last in the list)
This will show you how the social security number format works.

The idea behind this is that there is no connection whatsoever between
the *value* of a number, and the *format* of a number. Comparing in
Excel compares only the *value*.

--
Amedee Van Gasse using XanaNews 1.16.3.1
If it has an "X" in the name, it must be Linux?
Please don't thank me in advance. Thank me afterwards if it works or
hit me in the face if it doesn't. ;-)