Are you sure that you've got the parameters of the date function in the
right order, John?
Wouldn't it be =DATE(RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))
--
David Biddulph

"John C" <johnc@stateofdenial wrote in message
...
A1: 050180
A2: =DATE(LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2)
--
John C


"LauraNH" wrote:

If data is entered as mmddyy, how do I get it to change to mm/dd/yy? I
have
tried formatting the cell to no avail. HELP!