Format Cells... Number Date anything you want
--
Gary''s Student - gsnu200721


"Daniell" wrote:

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.