Hellow guys, Welcome to my website, and you are watching Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00"). and this vIdeo is uploaded by ExcelIsFun at 2013-12-27T13:31:58-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel Magic Trick 1058: Convert YYYYMMDD to Serial Number Date with =TEXT(A1,"0000-00-00") |
| Video Uploader | Video From ExcelIsFun |
| Upload Date | This Video Uploaded At 27-12-2013 21:31:58 |
| Video Discription | Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1056-1058.xlsx Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See Leonid Koyfman's great trick for converting YYYYMMDD (ISO 8601) dates to serial number dates in Excel using the formula =TEXT(A1,"0000-00-00"). |
| Category | Education |
| Tags | Excel 2013 | Excel 2003 | Excel 2007 | Excel 2010 | excelisfun | Mike Girvin | Highline Community College | Slaying Excel Dragons | Ctrl Shift Enter Mastering Excel Array Formulas | Leonid Koyfman | converting YYYYMMDD (ISO 8601) dates to serial number dates | converting YYYYMMDD dates to serial numbers | converting YYYYMMDD dates to serial number dates | Excel YYYYMMDD numbers to dates | TEXT function | Custom Number Formatting |
