date display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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


Todd said:
Silly question, How do I get the date format to work? I selected format
Click to expand...
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
 
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
 
Back
Top