How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy
=MID(A1,6,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4)
Vaya con Dios,
Chuck, CABGx3
"Amy Ann" wrote:
I tried going to format cells, then date, then the mm/dd/yyyy format. All I
get a #######. I tried expanding the cells but that didn't work either.
|