Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-07-2013, 08:35 PM
macropod's Avatar
macropod macropod is offline How to Suppress non-monetary 0 Windows 7 32bit How to Suppress non-monetary 0 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Another good reason for using field switches is that their use makes the formatting in the Word document independent of the formatting in the Excel workbook. For example, you might have numbers without thousands separators in Excel, but want them to show in the Word document; or you might want to differentiate between +ve and -ve values by colour - something you can't do via any kind of formatting at the Excel end. With dates, you might want to have day-of-week, date & month only, whereas Excel hold date, month & year, or you might want the date to appear in one format at one location and in another format somewhere else. All of this can be achieve via field switches in Word, with no changes to the datasource.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Suppress non-monetary 0 Suppress blanks in mail merge 0nyx175 Mail Merge 11 01-07-2014 02:45 PM
How to Suppress non-monetary 0 Easy mail merge but want to suppress rows ClaireAMAdams Mail Merge 5 04-30-2013 02:43 PM
How to Suppress non-monetary 0 How to auto add up the sum of monetary values? mikehende Excel 6 10-13-2012 12:40 AM
How to Suppress non-monetary 0 Suppress the Save prompt UTSUPPORT Word 1 01-16-2012 09:27 PM
Suppress Dialog Box crutch024 Word 0 08-17-2010 09:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:29 PM.


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