Two questions: I have a macro that converts the format of
a cell from general to text but the value inside the cell
doesn't change accordingly unless it is re-typed. Is
there some way to "refresh" the page to make the values in
the current cells recognize the new format?

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???