MS Office Excel Date-Time Code

[Guest]

I have been passed a date in the format of 39173. Is there a formula or
function that will convert from this format to a mm/dd/yyyy or yyyy/mm/dd or
even a dd/mm/yyyy? Thanks in advance for the help.

 

[Guest]

Format > Cells... > > Number > Date anything you want

 

[Dave Peterson]

How about just formatting that cell as a nice looking date:

Format|Cells|Number tab|choose your favorite date format.

 

[Gord Dibben]

To clarify responses see Chip Pearson's site on how Excel stores dates and
times.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben MS Excel MVP

 

[Guest]

Thanks for the help.