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.