Thread: How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default 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.

Reply With QuoteReply With Quote