Excel: text conversion to date format -


i convert text - apr 7 2017 date format on excel spread sheet. there formula might it? have tried format cell date format did not change cell properties. thank suggestions

with data in a1, in cell enter:

=datevalue(lookup(left(a1,3),{"apr","aug","dec","feb","jan","jul","jun","mar","may","nov","oct","sep"},{4,8,12,2,1,7,6,3,5,11,10,9}) & mid(substitute(a1," ","/"),4,99))

enter image description here

an alternative:

=datevalue(trim(mid(a1,5,2)) & "-" & left(a1,3) & "-" & right(a1,4))

Comments

Post a Comment

Popular posts from this blog

ios - Assigning a value out of array of arrays, using section in Xcode -

this code: let servicebonnen = [[1,2,3],[4,5,6],[7,8,9]] //not real data func tableview(tableview: uitableview, cellforrowatindexpath indexpath: nsindexpath) -> uitableviewcell { let cell = tableview.dequeuereusablecellwithidentifier("namecell", forindexpath: indexpath) cell.textlabel!.text = servicebonnen[section][indexpath.row] return cell } but gives me error @ "section" point in line of code: cell.textlabel!.text = servicebonnen[section][indexpath.row] does know why won't compile, , proper solution? you need use section indexpath : indexpath.section your line should this: cell.textlabel!.text = servicebonnen[indexpath.section][indexpath.row]
Read more

r - XTS-File doesnt work for quantstrat -

i have created xts file out of csv file looks this: open high low close volume adjusted 2016-01-04 14:30:36 "4896,3818" "4896,4272" "4895,2363" "4895,8789" " 0" "0" 2016-01-04 14:31:56 "4892,3579" "4894,0259" "4891,752" "4894,0259" " 0" "0" 2016-01-04 14:32:57 "4894,1753" "4899,2466" "4894,1753" "4898,8589" " 0" "0" 2016-01-04 14:33:59 "4899,2227" "4899,2227" "4894,8281" "4896,5469" " 0" "0" 2016-01-04 14:34:59 "4896,2915" "4896,418" "4892,3838" "4893,4326" " 0" "0" 2016-01-04 14:35:59 "4893,1196" "4896,3301" "4893,1196" "4895,434...
Read more