Main Profile

At A Glance

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
Length: 08:22

Contact

Questions about Excel Magic Trick 301: 1900 Date Problems and Fixes

Want more info about Excel Magic Trick 301: 1900 Date Problems and Fixes? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question