I convert an entire column of 9 digit identifiers using:

Columns("A:A").NumberFormat = "000000000"

I then try to compare the resulting values cell by cell to Zero. I get
a type mismatch error and when I check the cell formatting in excel it
is formatted under "Special" as a Portuguese Social Security Number.
I'm at a loss.....