When I format a column with mm/dd/yy, and then type the number 070706 in
the first cell, it sees the number as the number of days that has passed
since January 1, 1900, instead of 07/07/06. Is there a way to format the
column as a date so that when I do type the 070706 in a cell is displays
as the correct date? (07/07/06) Thanks, Shelly


--
ShellyD
------------------------------------------------------------------------
ShellyD's Profile: http://www.excelforum.com/member.php...o&userid=36167
View this thread: http://www.excelforum.com/showthread...hreadid=559476

Shelly

Are you game for some VBA?

See Chip Pearson's site.

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

Alternative...........

Start your date with an apostrophe '070706

When you have entered a great bunch of these use DataText to
ColumnsNextNextColumn Data FormatDateDMY or MDY to convert all.


Gord Dibben MS Excel MVP


On Fri, 7 Jul 2006 14:24:05 -0500, ShellyD
wrote:


When I format a column with mm/dd/yy, and then type the number 070706 in
the first cell, it sees the number as the number of days that has passed
since January 1, 1900, instead of 07/07/06. Is there a way to format the
column as a date so that when I do type the 070706 in a cell is displays
as the correct date? (07/07/06) Thanks, Shelly

hi Shelly,

excel work with dates as a number, 07/07/2006 for eg is 38,905, and 1 is
01/01/1900.

you could use an auxiliar column to transform 070706 in a date with this
formula, but 070706 should format as a text:

=date(20&right(a2,2),left(a2,2),mid(a2,3,2))

assuming that the 070706 is on a2.

hth
regards from Brazil
Marcelo






"ShellyD" escreveu:


When I format a column with mm/dd/yy, and then type the number 070706 in
the first cell, it sees the number as the number of days that has passed
since January 1, 1900, instead of 07/07/06. Is there a way to format the
column as a date so that when I do type the 070706 in a cell is displays
as the correct date? (07/07/06) Thanks, Shelly


--
ShellyD
------------------------------------------------------------------------
ShellyD's Profile: http://www.excelforum.com/member.php...o&userid=36167
View this thread: http://www.excelforum.com/showthread...hreadid=559476