Date Problem !!

C

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
 
B

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.
 
Top