Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-19-2024, 10:17 AM
tagyoureit tagyoureit is offline Unable to format numeric picture switch properly Windows 11 Unable to format numeric picture switch properly Office 2021
Novice
Unable to format numeric picture switch properly
 
Join Date: Aug 2024
Posts: 2
tagyoureit is on a distinguished road
Post Unable to format numeric picture switch properly

I'm trying to format a numeric merge field in Microsoft Word 365. I normally use a numeric picture switch like this:

\# 000000000000000000


This is what the full field code looks like:

{ REF bookmark \# 000000000000000000 \* MERGEFORMAT }
That's 18 total zeroes. I need to be able to have up to 18 digits showing with leading zeroes. If the referenced bookmark has 3 digits, I need 15 leading zeroes. If the bookmark has 15 digits, I need 3 leading zeroes. The length can be varied but always numbers. (There are no commas or dollar signs in the field.)


When I use the switch mentioned above, the number is rounded off after 14 digits. If my number is 1234567890123456, the number that appears is 001234567890123500. If I don't include the numeric picture switch and just use the ref field, the numbers aren't rounded off but also the leading zeroes don't appear. If possible, I need the switch to remain so I can keep those leading zeroes.


Any help will be greatly appreciated!!
Reply With Quote
 

Tags
field code, numeric picture switch



Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste in picture, wrap with line, format paragraph before and picture...close to working ctviggen Word VBA 3 03-25-2023 08:49 AM
IF statement for numeric picture switch jocotan88 Mail Merge 1 06-30-2021 06:40 PM
Unable to format numeric picture switch properly how to format a picture switch in a merge field to only include the numbers in the middle? becca Mail Merge 2 06-08-2016 01:15 PM
Format Switch \* Caps won't work in if..then statement cwright Word 2 03-27-2014 04:19 PM
Unable to format numeric picture switch properly Date format switch with If statement sbarron76 Mail Merge 3 05-03-2013 06:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 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