I have a large excel spreadsheet with several columns for phone numbers. In excel, the phone numbers are all typed as 1234567890 but are formatted as "special" and thus appear as (123) 456-7890.

When doing a WORD mail merge for address labels, I use the numeric picture switch (\#) to change the format to (123) 456-7890. This works perfectly for 2 out of 3 merge fields. It works for my { MERGEFIELD Home_Number \# "(000) 000'-'0000'} as well as { MERGEFIELD Cell_Number \# "(000) 000'-'0000'} It does not work for { MERGEFIELD Work_Number \# "(000) 000'-'0000'} It seems to pull random numbers that I can't find in my database at all. (the original database clearly has the correct phone number in the corresponding cell) When i take out the numeric picture switch, i'm left with the correct phone number but it displays 403319-3926 instead of 4033193926. (obviously i want it to display (403) 319-3926 ultimately) Where is it getting the hyphen from without the use of a numeric picture switch!? I'm so confused, i hope this is a weird glitch because I've tried EVERYTHING! this is my last resort, asking the computer gods!



ALSO! i've just noticed that although the original excel cells are correct, while editing the recipient list, the numbers are displaying just as mail merge is incorrectly displaying them. as 403319-3926... but it doesn't say that in the original! How do I change it!?