Excel Date conversions

Giganews Newsgroups
Subject: Excel Date conversions
Posted by:  Gerri (gpalom…@ci.concord.ca.us)
Date: Thu, 9 Oct 2003

How do I set up a column to automatically convert numbers
(example - 01012003) into a date format (example -
01/01/2003).  I tried doing this by format, cells, date -
then entered the number and the date came up different.