Date format

[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.

 

[Don Guillett]

Can you just highlight(select) the column and right
click>format>custom>mmddyyyy

 

[Dave Smith]

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