convert date to text in MS Excel

[2Plan]

Is there an easy way to convert this date '8/15/2007' to '081507'?

The dates are MS Excel.

 

[SkipVought]

Hi,

If you have REAL DATES, then use the TEXT function...
[tt]
=TEXT(yourdateref,"mmddyy")
[/tt]


Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[SkipVought]

...FYI, mmddyy will NOT sort as expected.

Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[SkipVought]

...you also could format your date field/column as Format > Cells - Number Tab - Custom...
[tt]
"mmddyy"
[/tt]


Skip,

_{When a wee mystic is on the loose..
It's a Small Medium at Large!}

 

[2Plan]

Works great!

You guys are goood.
Thanks.

 

[AnotherHiggins]

As Skip pointed out, sorting on mmddyy when it is stored as text won't work as expected.

Consider the format YYYYMMDD. That will sort by date, even if stored as text.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.