Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT296-301.xls
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT296-301Finished.xls
Full Page With All File Links: https://people.highline.edu/mgirvin/excelisfun.htm

See how to enter 1900 dates into cells. See how to change Regional Settings to force Excel to accept 1900 dates. See three amazing formulas to convert 1900 dates entered as text to serial number Excel dates:
1.LEFT, RIGHT, LEN, functions in one formula
2.SUBSTITUTE function
3.REPLACE (If third argument of REPLACE (num_chars) is zero, the function inserts text into a text string!)

See amazing formula solutions from the Mr Excel Message Board: barry Houdini, Andrew Poulsom

Please take the opportunity to connect and share this video with your friends and family if you find it useful.