You would need an event macro to change numbers into date like that, to
Excel
010101 = 10,101 meaning 10,101 days since Jan 0 1900 thus Aug 27 1927

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

how to install macros


http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom

"LauraNH" wrote in message
...
One other question...once I converted all my current data to that format
and
set all the following cells to have the date format of mm/dd/yy, when I
then
entered a date, for example 010101 it came out as 08/27/27. What
happened?

"JMB" wrote:

First, you need to convert the data to an actual date. Try clicking
Data/Text To Columns. Select Delimited, click Next, ensure all
checkboxes
under the Delimiters section are unchecked, click next, under Data Format
section select Date and MDY, click Finish.

Now XL should have converted your data to a date. You should be able to
change it to a different date format as needed.


"LauraNH" wrote:

If data is entered as mmddyy, how do I get it to change to mm/dd/yy? I
have
tried formatting the cell to no avail. HELP!