Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-07-2016, 06:20 PM
macropod's Avatar
macropod macropod is offline how to format a picture switch in a merge field to only include the numbers in the middle? Windows 7 64bit how to format a picture switch in a merge field to only include the numbers in the middle? 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

You could use a formula for your mergefield, coded along the lines of:
{=MOD(INT({MERGEFIELD MyField}/10),100) \# 00}
or:
{=MOD(INT(«MyField»/10),100) \# 00}
where 'MyField' is your field name.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to format a picture switch in a merge field to only include the numbers in the middle? Define custom Cross-reference output format to include "static" text and pg numbers cyclops755 Word VBA 9 01-17-2023 02:42 PM
how to format a picture switch in a merge field to only include the numbers in the middle? Custom format a merge field paul h Mail Merge 2 09-09-2015 07:18 AM
Macro to select an { includepicture } field code and format the picture behind text and 100% scale sanpedro Word VBA 3 03-30-2015 10:50 PM
how to format a picture switch in a merge field to only include the numbers in the middle? Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
how to format a picture switch in a merge field to only include the numbers in the middle? Adding a DASH in the middle of my field steven.allman Mail Merge 5 04-11-2011 02:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 AM.


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