Date format....

[ShellyD]

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

 

[Gord Dibben]

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 Data>Text to
Columns>Next>Next>Column Data Format>Date>DMY or MDY to convert all.


Gord Dibben MS Excel MVP

 

[Guest]

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: