| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change 20071201 to date
Hello. My little problem is that I want to change this date format: 20071201
to 2007-12-01, because excels doesn't recognize 20071201 as a date. I'm Dutch. I know the Dutch solution to the problem. It's: =DATUMWAARDE(RECHTS(A1;2)&"-"&DEEL(A1;5;2)&"-"&LINKS(A1;4)) However, I cannot make the translation work on an English version of excel. (...=DATEVALUE...?) Can anyone help me out? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change 20071201 to date
Maybe try Data Text to columns ?
Select the "dates" col Click Data Text to columns Click Next Next In step 3 of the wiz, Check "Date", then select: YMD from the droplist Click Finish -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Stampertje" wrote: Hello. My little problem is that I want to change this date format: 20071201 to 2007-12-01, because excels doesn't recognize 20071201 as a date. I'm Dutch. I know the Dutch solution to the problem. It's: =DATUMWAARDE(RECHTS(A1;2)&"-"&DEEL(A1;5;2)&"-"&LINKS(A1;4)) However, I cannot make the translation work on an English version of excel. (...=DATEVALUE...?) Can anyone help me out? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change 20071201 to date
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
and custom format the result cell like "yyyy-mm-dd"! Regards, Stefi €˛Stampertje€¯ ezt Ć*rta: Hello. My little problem is that I want to change this date format: 20071201 to 2007-12-01, because excels doesn't recognize 20071201 as a date. I'm Dutch. I know the Dutch solution to the problem. It's: =DATUMWAARDE(RECHTS(A1;2)&"-"&DEEL(A1;5;2)&"-"&LINKS(A1;4)) However, I cannot make the translation work on an English version of excel. (...=DATEVALUE...?) Can anyone help me out? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
Linear Mode
