| 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. |
| 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) | |||
Threaded Mode
