Changing Date Values!!! (dd/mm/yy) =(

[nutsaboutfruit]

Hi everyone.. im new to this forum

i joined because i wanted a solution to something thats been bugging me
ever since i got Excel

I am running Micrososft Excel 2003 in case you wanted to know...


The problem is this:

When i type a date in the format: (xx/yy/zz) - Excel recognises the xx
as the month (ie. mm/dd/yy)

When in fact i want it to recognise xx as the day (ie. dd/mm/yy)


That means every time i type (1/2/05) into a1
and
(2/2/05) into a2

i drag the rest and they come out like this:

1/2/2005
2/2/2005
3/2/2005
4/2/2005
5/2/2005
6/2/2005
7/2/2005
8/2/2005
9/2/2005
10/2/2005
11/2/2005
12/2/2005
1/2/2006
2/2/2006
3/2/2006
4/2/2006
5/2/2006
6/2/2006
7/2/2006
8/2/2006
9/2/2006
10/2/2006
11/2/2006
12/2/2006
1/2/2007
2/2/2007




See? it recognises the first two digits (xx) as the Month...

how can i get excel to recognise the date patterns in the form dd/mm/yy



Thanks in advance for your help!

 

[Jef Gorbach]

"nutsaboutfruit"

Hi everyone.. im new to this forum

i joined because i wanted a solution to something thats been bugging me
ever since i got Excel

I am running Micrososft Excel 2003 in case you wanted to know...


The problem is this:

When i type a date in the format: (xx/yy/zz) - Excel recognises the xx
as the month (ie. mm/dd/yy)

When in fact i want it to recognise xx as the day (ie. dd/mm/yy)


That means every time i type (1/2/05) into a1
and
(2/2/05) into a2

i drag the rest and they come out like this:

1/2/2005
2/2/2005
3/2/2005
4/2/2005
5/2/2005
6/2/2005
7/2/2005
8/2/2005
9/2/2005
10/2/2005
11/2/2005
12/2/2005
1/2/2006
2/2/2006
3/2/2006
4/2/2006
5/2/2006
6/2/2006
7/2/2006
8/2/2006
9/2/2006
10/2/2006
11/2/2006
12/2/2006
1/2/2007
2/2/2007




See? it recognises the first two digits (xx) as the Month...

how can i get excel to recognise the date patterns in the form dd/mm/yy



Thanks in advance for your help!

right-click the range and change cell format to custom: dd-mm-yy

 

[Adam]

Hi,

I believe it also takes your regional settings into account.

Go to Control Panel > Regional Settings

And make sure that the date is in the UK format.

 

[Ron Rosenfeld]

When i type a date in the format: (xx/yy/zz) - Excel recognises the xx
as the month (ie. mm/dd/yy)

When in fact i want it to recognise xx as the day (ie. dd/mm/yy)

This is determined by your Windows Regional Settings on PC's (or the equivalent
on the MAC).

Look at Start/Control Panel/...Regional Settings... (The last navigation will
differ depending on your display options.

Whatever your date format (I think the short date format) in that setting will
determine how Excel will interpret your input.

The date formatting within excel only determines how dates are displayed. It
has no effect on how excel interprets your input.


--ron