ExcelBanter - Modify general format to date format.

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

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

- - Modify general format to date format. (https://www.excelbanter.com/excel-worksheet-functions/262494-modify-general-format-date-format.html)

SherryS

Modify general format to date format.

When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these numbers into dates?

Jacob Skaria

Modify general format to date format.

If your Windows Regional Settings recognise a format of mddyyyy, you can
apply the below formula and format the formula cell to date..

=--TEXT(A1,"00\-00\-0000")

--
Jacob (MVP - Excel)

"SherryS" wrote:

When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these numbers into dates?

Teethless mama

Modify general format to date format.

=--TEXT(A1,"00-00-0000")

"SherryS" wrote:

When importing from payroll, it gives me all dates formatted as general
numbers (i.e. 07/17/2009 is presented as 7172009. Is there any way to
convert these numbers into dates?

All times are GMT +1. The time now is 04:32 PM.