Web Development

Ask something
Discussion Locked

Format Number Field to have Dashes

0 helpful
4 replies

by bambamz

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a file that was imported into Excel. The SSN field was imported as a text format. Now I am trying to mail merge the excel file to word but I cannot get the dashes in the SSN field. If I choose the format for SSN it shows in excel but does not go into the mail merge document. Please advise.

4 replies

by bambamz

I cannot change the format to dashes (special formatting) because it is text format.

by bambamz

I found this =LEFT(A2,3) & "-" & MID(A2,4,2) & "-" & RIGHT(A2,4) and it worked. Thanks for responding.

This discussion is closed to new replies.