|
| 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
February 20th, 2010, 02:17 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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
February 20th, 2010, 03:16 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
February 20th, 2010, 04:03 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 | |
|
|
Linear Mode
