Thanks for responding and teaching. Would that be the same (but perhaps easier) than
VALUE(REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2)))
Formatting either to a date just happens to return the same date.
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | D1 | =REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2))+0 |
D2 | D2 | =0+REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2)) |
D3 | D3 | =VALUE(REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2))) |
D4 | D4 | =REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2))*1 |
D5 | D5 | =1*REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2)) |
D6 | D6 | =--REPLACE(LEFT(C1,4),1,0,RIGHT(C1,2)) |