Excel Forum
Similar Content
Calculate the Total Time Worked Minus Lunch Breaks in Excel
Tutorial: Ill show you how to use Excel to calculate the total time worked in a day minus lunch tim...
5 Must Know Paste Special Tricks
Tutorial: The 5 best things you can do with the Paste Special command in Excel, with examples. Secti...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...

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.