Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

how do I insert Item numbers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EJ Jacques - 23 May 2008 23:53 GMT
I have 5 sheets of products and I want to create random item numbers (6
digits). This is a basic inventory list.
FSt1 - 24 May 2008 00:30 GMT
hi
no you don't. trust me.
you want to create catagories for your products with 2 or 3
characters(letters or numbers so long as it follows a logical order) to
start. you may want a seperator such as a dash(-) then products numbered
sequentually. this brings some sort of order to your inventory numbering
system.
you can then manage your inventory by catagory(smaller groups) instead of
trying to digest the whole inventory at one time.
opinions do vary on this topic as to methodology but some sort of order to
the inventory system is paramount. avoid anything and everything that has
something to do with "random".

regards
FSt1
member APICS

> I have 5 sheets of products and I want to create random item numbers (6
> digits). This is a basic inventory list.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.