Thread: [Solved] Problems merging in last 4 digits of an account higher than 16 digits
View Single Post
 
Old 04-07-2011, 02:51 PM
Glynda Glynda is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Mar 2011
Location: Nashville, TN
Posts: 2
Glynda is on a distinguished road
Smile 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?
Reply With Quote