How do I convert Date formatted cells received from others (such as 1-5-05 or 2/18/2005,etc) to a Text format of 010505 or 021805? When I try, I just get what appears to be the right format (010505 or 021805) but it is not Text. I must have Text.
