Date programming

[Guest]

Is it possible to format a date to appear as 00/00/00 by only entering the 6
numbers and not the slashes?

 

[JE McGimpsey]

See

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

 

[Gord Dibben]

MeMe

Not without using VBA code.

See Chip Pearson's site for methods.

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


Gord Dibben MS Excel MVP