Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 08-26-2015, 05:32 AM
macropod's Avatar
macropod macropod 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 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,526
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could format the entire column as Text. That way, Excel will accept numbers from 1 to 32,767 digits and will display up to 1,024 digits. No formulae required - and you can even have leading 0s.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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 01:03 AM.


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