Date Problem !!

[cassy01]

hi there i have a big problem with the dates. i enter 09/10/2005 in a cell and it changes to 10/09/2005 !! big problem.

it shows 10/09/2005 in the cell but 09/10/2005 in the formula bar !! 2 different dates very confusing is there a way of telling it to use just one kind ??? thanks

[BekkiM]

It's the same date, it's just formatted differently on your spreadsheet (at
least, I assume that if you entered 03/25/2005 you would see 25/03/2005). To
correct, select the cells with dates (individual cells, whole columns, whole
rows, etc) and then select Format | Cells | Number. Pick "Date", then select
the format you want.

"cassy01" wrote:

>
> hi there i have a big problem with the dates. i enter 09/10/2005 in a
> cell and it changes to 10/09/2005 !! big problem.
>
> it shows 10/09/2005 in the cell but 09/10/2005 in the formula bar !! 2
> different dates very confusing is there a way of telling it to use just
> one kind ??? thanks
>
>
> --
> cassy01
> ------------------------------------------------------------------------
> cassy01's Profile: http://www.excelforum.com/member.php...nfo&userid=780
> View this thread: http://www.excelforum.com/showthread...hreadid=473175
>
>