date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

afdmello - 29 Mar 2008 23:41 GMT

using 2007

when doing fill down the date changes from 28.03.08 to 28.03.09 any idea
why???

AFD

Reply to this Message

Gord Dibben - 30 Mar 2008 00:09 GMT

Do you not see my reply of yesterday?

Here it is again.............................

What are the settings for Short Date under your Windows Regional Seetings.

28.03.08 may not be a valid date and is treated as text.

What happens when you enter a date such as 3/23/08 and copy down?

Gord Dibben MS Excel MVP

>using 2007
>
>when doing fill down the date changes from 28.03.08 to 28.03.09 any idea
>why???
>
>AFD

Reply to this Message

afdmello - 05 Apr 2008 21:08 GMT

Gord,

The short date in regional setting is 3/23/08.
when I input date as3/23/08 it is accepted as date and the fill handle works
well. but if date is input as 23.03.08( read as march 23 08) then fill
handle fills as 23.03.09, this occurs even though the format cells is
selected as date format.

Afd

> Do you not see my reply of yesterday?
>
[quoted text clipped - 14 lines]
>>
>>AFD

Reply to this Message

Gord Dibben - 05 Apr 2008 21:36 GMT

Your short date settings are m/dd/yy

Why are you attempting to enter dates as dd/mm/yy?

These become text when entered so the incrementing works as it should for text.

Simply changing the format in Excel will not turn 23.03.08 into a valid date.

With the 23.03.08 type dates, run them through Data>Text to Columns

Data>Text to Columns>Next>Next>Column Data Format>Date>DMY will change 23.03.08
to 3/23/08

Gord

>Gord,
>
[quoted text clipped - 24 lines]
>>>
>>>AFD

Reply to this Message