Discussion Locked
Excel change Date to mmddyy as Text only
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.