How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy
 

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.

How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy
 

It might be that your data is in text format, so reformatting the
cells won't work. Assuming your birthdate is in A1, try this in B1:

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

Format this cell as mm/dd/yyyy.

Hope this helps.

Pete

On Dec 13, 5:48 pm, Amy Ann <Amy
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.

How do I convert a birthdate format from yyyy/mm/dd to mm/dd/y
 

If dates are text formatted you can convert to true dates this way.

Select column Data Text to columns Next Next under "Column data
format" select "Date" and specify YMD Finish

"Pete_UK" wrote:

It might be that your data is in text format, so reformatting the
cells won't work. Assuming your birthdate is in A1, try this in B1:

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

Format this cell as mm/dd/yyyy.

Hope this helps.

Pete

On Dec 13, 5:48 pm, Amy Ann <Amy
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.

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.