Issues with dates

When I typed 072806 in an excel formatted date column it came up 5/01/2099.
The only way I was able to keep the dates I want is to actually type 7/28/06.
I do not usually type the / when entering dates in a formatted column.

Dates cannot be entered without a separator like / or -

If you "do not usually type the /" then you have some code running.

You can use VBA event code for quick entry as you want.

See Chip Pearson's site for this.

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

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

Format the cells as Text.........enter your 072806 and many more like it in
successive cells until you have all your dates entered.

Then Data>Text to Columns>Next>Next>Column Data Format>Date>MDY>Finish.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 07:16:02 -0700, JS <[email protected]> wrote:

>When I typed 072806 in an excel formatted date column it came up 5/01/2099.
>The only way I was able to keep the dates I want is to actually type 7/28/06.
> I do not usually type the / when entering dates in a formatted column.