| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| change date format from dd/mm/yyyy to mm/yyyy | Excel Discussion (Misc queries) | |||
| convert date mm/dd/yyyy to dd/mm/yyyy | Excel Worksheet Functions | |||
| how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel | New Users to Excel | |||
| How to convert the dates from the YY:DD forma to MM/dd/YYYY format | Excel Worksheet Functions | |||
Linear Mode
