General discussion

Locked

Excel change Date to mmddyy as Text only

By vwrman ·
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.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Excel change Date to mmdd ...

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.

Collapse -

I have used the TEXT command.

by vijayakumari.ch In reply to

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.

Back to Windows Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums