Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-25-2015, 10:47 AM
howie707 howie707 is offline Formula for tracking (shipping) numbers when number of characters change Windows 7 64bit Formula for tracking (shipping) numbers when number of characters change Office 2010 64bit
Novice
Formula for tracking (shipping) numbers when number of characters change
 
Join Date: Dec 2013
Posts: 8
howie707 is on a distinguished road
Unhappy

Hello, I can not find any info in regard to "tracking numbers" and hope that someone can help me. We have FedEx, UPS and other shippers that we use. I have a column titled TRACKING and when I put one type of Fedex number in (15 character) I can use the formula Number set it to -0- decimal places and I can insert the number. Then Fedex has other numbers with (22 characters) I can change the formula in that cell to TEXT and it will work. We have another shipper that only uses (8 characters) . Can ANY ONE tell me how I can set the formula to accept the tracking number in each cell without having to change it each time? I have the 2007 Excel Book by John Walkenbach and could not find anything in it either. I think when you use the word tracking in your query, it throws the search off and you end up in places that make no sense. I would be so grateful for ANY help. Stephanie



I actually have win 8.1 pro office 2013 if this makes any difference
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Turn off change tracking in Word Online/OneDrive jorenste Word 3 06-17-2015 10:46 PM
change tracking eNGiNe Visio 0 01-16-2015 05:26 AM
Formula for tracking (shipping) numbers when number of characters change Unwanted change tracking on numbered headings copycath Word 2 06-05-2014 10:50 PM
Formula for tracking (shipping) numbers when number of characters change Highlight the first X number of characters 14spar15 Word 1 11-13-2011 11:17 PM
Problem With Word Change Tracking Benross33 Word 1 09-10-2009 06:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:03 PM.


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