Thanks Dave.

"Dave Peterson" wrote:

If the SSN is stored as real numbers, then the number format will work nicely.

If the SSN was entered as text, then the number format won't change it.

You may have to reformat the cell as General (or some number) and then reenter
the value (without the dashes).



Alex wrote:

I used SSN formatting for cells and nothing happened to the data in one
column, but when is used the same formatting for another column of data, the
data immediately changed to the SSN format. Why?

--

Dave Peterson