Date Problem !!
 

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

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