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
|