Windows

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

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.

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.

Related Discussions

Related Forums