serial number

I need to convert a date into a serial number. The serial number must return the format DDDYYNN where DDD is the day of the year, YY is the year, and NN is the sequential build number. As an example, if 10 units are built on 2/6/2013, the serial numbers would be 0371301, 0371302 ...0371310. Cell...

Hi, I have an excel file to keep track of inventory. 1st tab is an overview of the quantity available for each item. column A "Product Code", column B "Description", column C "Qty on 12/1/12", column D "Qty In", Column E "Qty Out", Column F "Total on Hand". 2nd tab in the tab where I insert...

Hi Ladies and Gents, I have been reading through some of the older questions and couldn't put together my answer without asking for help. Basically what I am looking to do is take a serial number and have it increase by one. The problem however is that the number ends with a letter not a...

Hi , I am in the midst of fundraising for a Gala Day and I need to creat tickets for a bingo tea. I want serial numbers on them to avoid counterfieting. (Yes, it is that type of place) I am looking to have the serial number in Column E Due to the text the Rows are likely to be 4,8 , 16 etc...

I'm using a formula to pull data from other columns in order to automatically complete a phrase. The formula looks like ="language" & A1 & "other language" & B1, with A1 being the date. The date displays in standard date format in A1, but once used in the formula, it converts to the serial...

I have been trying to type a date in a column in MS excel. But excel always reads it as a serial number. How Can I get it to display the date as it is in date format. I have the next column formatted/ formulated to display the day of the date in the previous column.