Hi,

I'm using Office 2003 and have, what I hope to be, a simple question.

My data is in an Excel file. I have a list of ssn numbers with a "special"
format selected to display them correctly. i.e. 123456789 is displayed as
123-45-6789.

When I do the mail merge into Word it looses this formatting, I'm assuming
because word sees it as a number and not text?

Is there a way around this or do I have to update all my ssn numbers in
excel to text? If I just change the format to text, then I'll loose the
"-". I rather not re-type everything.

Thanks,

Lisa