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) |