Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-07-2011, 02:51 PM
Glynda Glynda is offline Problems merging in last 4 digits of an account higher than 16 digits Windows 7 32bit Problems merging in last 4 digits of an account higher than 16 digits Office 2007
Novice
Problems merging in last 4 digits of an account higher than 16 digits
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Projects C_Howard Project 2 03-29-2012 02:00 PM
How to delete first 6 Digits and one Space from a CELL? Learner7 Excel 3 08-10-2010 04:06 AM
Merging or Cut and Paste AnnieM Word 1 06-24-2010 03:03 AM
Help with merging? yazakib Mail Merge 0 04-11-2010 01:24 PM
Merging documents Stattovic Word 7 01-31-2010 03:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft