Does it help if you format the fields as "text" in Excel in stead of "general".
Else fill them with a hard space (alt-0-1-6-0) as a work-around for not knowing how to use IF.
I have a mail merge from excel to Word and all the blank cells are coming through as 0's. How do I keep them blank or empty? Im using MS Word 2010. I saw post from 2007 and tried to use formula but that did not work. I tried to use IF...Then but I've never used it before so maybe I am doing something wrong it was just deleting the merge fields if it was 0.