Excel Forum

Excel Magic Trick 301: 1900 Date Problems and Fixes

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

Got a Question? Ask it Here in the Forum.