How do I create a basic inventory database in Excel that will print labels?
How do I create a basic inventory database in Excel that will print labels?
I need each label to have both letters and numbers within the sku. I want it to be able to fill in the graduated sku list itself, without me having to type SLT0001, SLT0002…etc. Any ideas or easy formulas that you know of? I want to do this in Excel or Word, not an inventory program. Doesn’t have to be extensive just basic. Thank you!
Tags: basic, create, database, Excel, inventory, labels, print
Under Forum
1 Comment for How do I create a basic inventory database in Excel that will print labels?
1. www.Aeternus.sg | November 24th, 2010 at 10:47 pm
You can use custom number formatting to do this.
Select all the cells that you want to enter SKUs. Right-click and select “format cells”.
On the FORMAT CELLS dialog box do this:
Go to the “Numbers” Tab, Select “Custom” category. In the “Type:” field, key in this: “SLT”#. Click OK.
Now you just need to enter numbers and the cell will automatically display “SLT” in front of the number you have typed.
Leave a Comment for How do I create a basic inventory database in Excel that will print labels?
You must be logged in to post a comment.
Trackback this post | Subscribe to the comments via RSS Feed