| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
date is in 20010129 format, how can I get it in m/d/y format
-- jsanders |
|
#2
|
|||
|
|||
|
Datatext to column, go to step three and select date and YMD
and for future posts it's considered rude just using the subject line Regards, Peo Sjoblom |
|
#3
|
|||
|
|||
|
With the value 20010129 in cell A1, enter this formula in B1:
=DATEVALUE(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4)) and the format the cell as a date. The various functions parse the 20010129 string into its components, and the DATEVALUE converts that string to a datevalue that Excel can recognize. |
| 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) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Hybrid Mode
