I hope someone can help because this is driving my crazy...
I have a spreadsheet of costs that is merged to a word document. The columns are all formatted as currency and contain either a numerical value or the word "no". When merging, some of the columns merge correctly and the word no appears but in one column the no's appear as a 0. Reformatting does nothing, the only way I've been able to change it is to use the text or trim function to force everything in the column to text. I then get the no's to appear but I lose the currency formatting. If I change the formatting on only the numbers in the column back to currency it casues the no's to go back to merging as zeros.
Any help would be appreciated!
I have a spreadsheet of costs that is merged to a word document. The columns are all formatted as currency and contain either a numerical value or the word "no". When merging, some of the columns merge correctly and the word no appears but in one column the no's appear as a 0. Reformatting does nothing, the only way I've been able to change it is to use the text or trim function to force everything in the column to text. I then get the no's to appear but I lose the currency formatting. If I change the formatting on only the numbers in the column back to currency it casues the no's to go back to merging as zeros.
Any help would be appreciated!