date display

[Todd]

Silly question, How do I get the date format to work? I selected format cells>number>date>03/04/97. But it doesn't work. 070200 becomes 3/12/92 instead of 07/02/00 What am I doing wron

 

[Peo Sjoblom]

Because you live under the impression that Excel can tell the difference
between the integer 70200 and the date 070200, it can't! You either have to
use
VBA

http://www.cpearson.com/excel/DateTimeEntry.htm

or use a date delimiter that Excel recognizes..


--

Regards,

Peo Sjoblom

Silly question, How do I get the date format to work? I selected format

cells>number>date>03/04/97. But it doesn't work. 070200 becomes 3/12/92
instead of 07/02/00 What am I doing wrong

 

[Gord Dibben]

Todd

See Peo's answer also.

If the dates are already there in the format you say. 070200

=DATE(VALUE("20" & RIGHT(A2,2)), VALUE(LEFT(A2,2)), VALUE(MID(A2,3,2)))

Will change to 07/02/2000. Reformat as you wish.

Gord Dibben Excel MVP