| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert serial number into date
Hi,
Can anyone tell me how to convert a serial number into date? For example: 01-OCT-06 is stored as 38991 in MS excel (i get this thru edate function). I want to get the date using the serial number 38991. thanks Santhu |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert serial number into date
Just Format as Date (FormatCellsNumber tab, Category Date, choose a format)
-- Kind regards, Niek Otten Microsoft MVP - Excel "santhu" wrote in message oups.com... | Hi, | | Can anyone tell me how to convert a serial number into date? | | For example: | | 01-OCT-06 is stored as 38991 in MS excel (i get this thru edate | function). I want to get the date using the serial number 38991. | | thanks | Santhu | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert serial number into date
Or, if you want text: =TEXT(A1,"dd-mmm-yy")
-- Kind regards, Niek Otten Microsoft MVP - Excel "santhu" wrote in message oups.com... | Hi, | | Can anyone tell me how to convert a serial number into date? | | For example: | | 01-OCT-06 is stored as 38991 in MS excel (i get this thru edate | function). I want to get the date using the serial number 38991. | | thanks | Santhu | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Date to number? | Excel Worksheet Functions | |||
| Convert Date to Serial Date? | Excel Discussion (Misc queries) | |||
| date displays as serial number | Excel Discussion (Misc queries) | |||
| How do I convert Date serial number to date | Excel Worksheet Functions | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Linear Mode
