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.

2 replies

by bfilmfan

Have you used the Text command?

Based upon the example in your question above with a cell formatted to 01/01/2005, the command =TEXT(A1,"ddmmyy") would return 010105.

by vijayakumari.ch

Im using the Text command. even though my date is not getting changed to text format.

eg:
function (){
val = TEXT(date,"yymmdd");
}
Please specify the conversion of date to text format using javascript.

This discussion is closed to new replies.