Hello,
I have had 2 instances recently where I have struggled with merging excel into a mail merge and the format did not merge correctly.
In the first, I had a per diem automatically calculated, which generated a very long decimal point. I formatted it to 2 decimals, however when it merged, it showed the whole number. No matter how many times I tried to rework the sheet it did not fix it. I had to manually change the sheet to text and override each cell to the number I wanted shown.
In the second, it was numbers that were formatted to phone numbers. Same issue. Is this an excel issue? A word issue? Is there a trick to this?
I appreciate any help!
I have had 2 instances recently where I have struggled with merging excel into a mail merge and the format did not merge correctly.
In the first, I had a per diem automatically calculated, which generated a very long decimal point. I formatted it to 2 decimals, however when it merged, it showed the whole number. No matter how many times I tried to rework the sheet it did not fix it. I had to manually change the sheet to text and override each cell to the number I wanted shown.
In the second, it was numbers that were formatted to phone numbers. Same issue. Is this an excel issue? A word issue? Is there a trick to this?
I appreciate any help!
