•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
datevalue() doesn't figure this out.
This is how the date/time comes in a csv file. It's text. Can't sort properly because the the 3 letters as month. Single digit days don't have leading zero. Single digit hours don't have leading zero. It's like they generate it to be as annoying as possible. This is exported from Teamviewer by the way.
Apr 2, 2026, 4:16 PM
Apr 1, 2026, 10:15 AM
Mar 31, 2026, 5:10 PM
You would think that datevalue could figure it out.
Any suggestions?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#real-time data collaboration
#real-time collaboration
#Excel alternatives
#datevalue
#csv
#leading zero
#Teamviewer
#text
#month
#date/time
#sorting
#single digit
#time
#hours
#days
#exported