#1
|
|||
|
|||
field code question
I know this is easier than I am making it...I need to merge in a money field into a Word template. I would like it to format with the $ in front of the number if the amount is greater than zero, but if the amount is zero or less I'd like it to just be blank. Is there a way to do that?
|
#2
|
|||
|
|||
Merge cell
I would read up on conditional formatting in Excel, then link your info in the Word document.
|
#3
|
|||
|
|||
Thanks for the advice...I'm not following you completely, though...do you mean in the Word doc link to an excel spreadsheet? I have some Word experience but I am not all that advanced at it. The template I am setting up will be a template that uses a data source created by another software program. The output is basically a flat text file. The data is merged automatically by the software program, so I would not be able to introduce Excel into the equation.
|
#4
|
|||
|
|||
Money field
I see. Well, what I was getting at, was using the formatting possibilities in the data source application to determine the data to be inserted. I regret that I am a novice in VBA programming (Word's language), so I don't know how to write a field that would do what you want. I suspect that it can be done with something called switches, which can operate somewhat like conditional formatting, but I don't know for sure. If you do get a solution, I'd love to see it. Sorry I can ;t be of more assistance.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail merge Field Code Manipulation | macjnr | Mail Merge | 0 | 09-10-2009 11:37 AM |
Styling 'code' in word | scottyearl | Word | 0 | 03-08-2009 09:18 AM |
Misplaced Post Code | Doc John | Word | 0 | 02-05-2009 05:38 AM |
Categories question & replying with attachment question | glitzymama | Outlook | 0 | 03-15-2006 09:32 AM |
FileSaveAs with Code | bsmith | Office | 0 | 01-05-2006 08:43 AM |