Modify general format to date format.

  • Thread starter Thread starter SherryS
  • Start date Start date
S

SherryS

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?
 
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")
 
Back
Top