| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date conversion
I want to convert a number i.e. 041006 into a date, having
formatted the new cell as date: dd/mm/yyy. When I use the formula =DATE(left(D13,2),MID(D13,3,2),right(D13,2) I get the date 06/10/1904, when it should be 06/10/2004. Any suggestions please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
| Disable automatic date conversion feature | Excel Worksheet Functions | |||
Threaded Mode
