Date format

  • Thread starter Thread starter Jonathan Smith
  • Start date Start date
J

Jonathan Smith

I need to change a column of data from YYYYMMDD format
into MMDDYYYY. The data is extracted from our Hospital
Information System into Excel and the column of cells
have a "General" format. Any help is greatly appreciated.
 
Can you just highlight(select) the column and right
click>format>custom>mmddyyyy
 
If this doesn't work, you can try this:

=MID(A1,5,2) & RIGHT(A1,2) & LEFT(A1,4)

but I would use something more like this to get real dates and format the
cells appropriately:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

HTH
Dave
 
Back
Top