![]() |
#1
|
|||
|
|||
![]()
Hi there. I am looking for a merge switch that will return the last 4 digits of a 16 digit number. I've searched a number of threads and forums on this topic and found the following:
{=MOD({MERGEFIELD ACCOUNT_NUMBER },10000 \#0000 } However, I am finding that the switch rounds the last of the 4 digits up. I attempted to include a minus 1 calculation in the switch but this only works for numbers 0 to 8 because number 9 returns a zero. As an example if the last 4 digits is 1239 the switch returns 1230 so deducting 1 makes it 1229. Does anyone know if there is a way to fix this? Thank you in advance of any help. Regards. Mac |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
shahid.majeed | Mail Merge | 4 | 09-19-2019 01:08 AM |
Entering a number of 19 digits | Jo Freeman | Excel | 11 | 11-08-2017 06:20 AM |
Having number's digits together | mohsen.amiri | Word | 0 | 06-23-2017 01:20 AM |
![]() |
gugootz | Word | 1 | 11-23-2015 04:58 PM |
Use a numerical merge field to subtract that number of months | MichaelSpedding | Mail Merge | 8 | 11-11-2015 01:11 PM |