![]() |
|
#1
|
|||
|
|||
![]()
Even though if I have syntax error now values are returning.
I have 13 values which are coming from field,11 values are coming as expected but other two values are not populating ,its coming as -8 -8 . Do I need to make any change in formula ? This is My Formula, {=MOD(INT(«ACCOUNT_NUMBER»/100000000000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/10000000000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/1000000000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/100000000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/10000000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/1000000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/100000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/10000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/1000),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/100),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/10),10)\#0} {=MOD(INT(«ACCOUNT_NUMBER»/1),10)\#0} Received Output Value: 0 1 3 0 1 0 9 1 7 6 1 -8 -8 <<<<<like this Expected Output Value: 130109176110 Thanks, Naveen |
![]() |
Tags |
mergefields, table, word 19 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Field has multiple values how get those multiple values into one row | madiso10 | Excel | 1 | 06-02-2017 04:48 AM |
![]() |
tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
![]() |
eduams | Mail Merge | 1 | 09-26-2016 07:02 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
![]() |
Beowolf | Mail Merge | 1 | 03-07-2014 03:26 PM |