Problems merging in last 4 digits of an account higher than 16 digits
I'm having problems merging in the last 4 digits of a 17 digit number. I found a switch that works for a 16 digit number but when the number is higher than 16 digits it rounds the numbers. Do you know if there switch format that will pull in the last 4 digits of a 17 digit number without changing the excel data file?
|