Quote:
Originally Posted by KevCarter
The solution I use is to create the additional field "Petitioner_Att_Bar_Text" in my EXCEL table using the formula
= TEXT(Petitioner_Att_Bar,"$###,##0.00;-$###,##0.00;")
and using that field in the mail merge.
Mr. Edstein, is there a downside to attacking the problem in this manner?
|
Hi Kevin,
The disadvantage that immediately springs to mind is the fact you need to modify the datasource - adding an extra column for every existing column that has the problem 0s in it. In some organisations, that would be frowned upon - or simply not possible (e.g. one generally can't go around modifying corporate databases).
Quote:
|
I'm not very comfortable writing this type of procedure in WORD, I can't seem to remember the proper syntax and / or function keys to get there
|
Fair enough, but that's why we have word-processors, etc., where one can store notes (which in this case require little more than a quick copy/paste) for things we don't use very often. Doubtless you have something such already for Excel...
12-07-2013, 09:10 AM
Similar Threads
Suppress blanks in mail merge
Windows 7 32bit 
Office 2010 32bit
Hybrid Mode