Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2009, 07:30 AM
bordercollie10 bordercollie10 is offline field code question Windows XP field code question Office 2007
Novice
field code question
 
Join Date: Feb 2009
Posts: 5
bordercollie10 is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 10-14-2009, 07:03 AM
Ulodesk Ulodesk is offline field code question Windows XP field code question Office 2007
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 861
Ulodesk is on a distinguished road
Default Merge cell

I would read up on conditional formatting in Excel, then link your info in the Word document.
Reply With Quote
  #3  
Old 10-15-2009, 06:35 AM
bordercollie10 bordercollie10 is offline field code question Windows XP field code question Office 2007
Novice
field code question
 
Join Date: Feb 2009
Posts: 5
bordercollie10 is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 10-15-2009, 07:55 AM
Ulodesk Ulodesk is offline field code question Windows XP field code question Office 2007
Word 2013 Expert Cert
 
Join Date: Sep 2009
Location: Virginia
Posts: 861
Ulodesk is on a distinguished road
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft