Formatting Dates

Posted by Greg on December 10, 2001 10:50 AM

I have received dates in the following format: 12062001 (formatted to be text). How do I change the cell so that it reads 12/6/2001 without a ton of steps? Is there an easier way than text to columns a few times and then consolidating them into one cell? Any ideas would be appreciated, thanks.
Greg

Posted by Mark W. on December 10, 2001 11:11 AM

Text to columns... a few times? You only need
to perform text to column once! See...
9042.html

Posted by Greg on December 10, 2001 11:41 AM

That only works if they put a 0 in front of the first nine months or if it 10,11 or 12 for the first month. Then what do you do?
Thanks

Posted by Mark W. on December 10, 2001 11:52 AM

Add a leading 0 using...

=REPT(0,8-LEN(A1))&A1