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...
Find the Next Blank Row with VBA Macros in Excel
Tutorial: Learn how to find the next empty cell in a range in Excel using VBA and Macros.  This meth...
Format Cells in The Short Date Number Format in Excel
Macro: This free Excel macro applies the Short Date number format to a selection of cells in Exce...



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.