Using your formula below, 20071225 yields 12/25/2007
R Ron Rosenfeld Dec 13, 2007 #22 Using your formula below, 20071225 yields 12/25/2007 Click to expand... Well, at least that gives you a method of converting the date. But I sure don't understand why the Data/Text-to-Columns wizard fails. --ron
Using your formula below, 20071225 yields 12/25/2007 Click to expand... Well, at least that gives you a method of converting the date. But I sure don't understand why the Data/Text-to-Columns wizard fails. --ron
