If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i use the daye function to insert a serial number
how do i use the date function to insert a formula that inserts a serial
number for a specific date |
#2
|
|||
|
|||
how do i use the daye function to insert a serial number
If you format the cell where the date is entered as 'number' then this gives
a unique number. However I suspect what you need is not so simple and therefore requires fuller explanation please. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "stephanieylalo" wrote: how do i use the date function to insert a formula that inserts a serial number for a specific date |
#3
|
|||
|
|||
how do i use the daye function to insert a serial number
See help on DATEVALUE function.
=DATEVALUE("2/20/2010") or "20/2/2010" depending upon Regional settings for date entry. Gord Dibben MS Excel MVP On Sat, 20 Feb 2010 06:17:01 -0800, stephanieylalo wrote: how do i use the date function to insert a formula that inserts a serial number for a specific date |
Thread Tools | |
Display Modes | |
|
|