On Sat, 16 Jul 2005 16:03:03 -0700, "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?

An even quicker solution is to select the column, click Data -- Text
to Columns, check Fixed Width and hit Finished. The conversion to
numeric values (if they were text) will continue to use the format
you'd previously applied (i.e. SSN formatting) so you save a step by
not having to go back and change it to SSN formatting again.
--
"Learning is a behavior that results from consequences."
B.F. Skinner