Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Date Formula Problem | Excel Worksheet Functions | |||
Login Logout Date Problem | Excel Worksheet Functions | |||
Identifying Date Overlaps | Excel Discussion (Misc queries) | |||
Date and Time Picker Control problem | Excel Discussion (Misc queries) | |||
dsum with date criteria | Excel Worksheet Functions |