| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Portuguese Social Format NOT desired
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..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Input box accepting only desired format | Excel Programming | |||
| How do I format a social security number to have no dashes? | Excel Discussion (Misc queries) | |||
| format social security number | Excel Worksheet Functions | |||
| Social Security Number format | Excel Worksheet Functions | |||
| format social security number as XXX-XX-1234 | Excel Programming | |||
Threaded Mode
