ExcelBanter - date conversion

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - date conversion (https://www.excelbanter.com/excel-worksheet-functions/21711-date-conversion.html)

rdunne

date conversion

How can I convert a date serial number back to date format?

Duke Carey

Fredrik answered this for you earlier today

Just format it as a date

"rdunne" wrote:

How can I convert a date serial number back to date format?

PCLIVE

Right-click on cell.
Select 'Format cells...'
Select 'Date'.
Then select the desired formatting type.

Regards,
Paul

"rdunne" wrote in message
...
How can I convert a date serial number back to date format?

All times are GMT +1. The time now is 06:18 PM.