Changing Date Format

[Harley]

In column A I have about 10,000 dates in this format: 06-Mar-02

In column B I want these dates to read 030602. How can I change the format?

[AJ]

Just have a custom format:

mmddyy

That do the trick?

[paulyf]

Hi

Format->Cells->Custom

then type: mmddyy

Cheers - Paul

[Harley]

AJ...should have mentioned that I already tried that...for some reason that doesn't do the trick...any other ideas?

[Mark W.]

On 2002-04-05 08:29, Harley wrote:
AJ...should have mentioned that I already tried that...for some reason that doesn't do the trick...any other ideas?

Select your "dates", choose the Edit | Text to Columns... menu command, and press [ Finish ]. Now apply the previously recommended format.

[Harley]

Mark W....perfect...thanks...what does that "Text To Columns" do?

[ This Message was edited by: Harley on 2002-04-05 08:53 ]

[Mark W.]

On 2002-04-05 08:50, Harley wrote:
Mark W....perfect...thanks...what does that "Text To Columns" do?

[ This Message was edited by: Harley on 2002-04-05 08:53 ]

The data type of a value is established upon data entry. Evidently, these "date" values were imported as Text. To get Excel to recognize 'em as true dates you could have edited each cell individually, but that would be laborious. Edit | Text to Columns... forces Excel to edit the cells and re-evaluate the data type assignment.