Is there a way to enter just the numbers 032107 and have it display the date 03/21/07?
E excel-duh? Apr 5, 2007 #1 Is there a way to enter just the numbers 032107 and have it display the date 03/21/07?
B Bob Phillips Apr 5, 2007 #3 There is a free Excel addin that does this, http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
There is a free Excel addin that does this, http://www.xldynamic.com/source/xld.QDEDownload.html -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
E excel-duh? Apr 7, 2007 #4 To T. Valko and Bob Phillips. Thank you for your quick assistance. This newby to Excel and this Discussion site appreciates the help offered by veterans like you.
To T. Valko and Bob Phillips. Thank you for your quick assistance. This newby to Excel and this Discussion site appreciates the help offered by veterans like you.