Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help needed with date format
I've always entered date as yy-mm-dd. In fact when I want to enter Aug 28, 2005, I would only need to enter "5-8-28".
With the proper formatting on the cells, the date will be displayed as "2005-08-25", or "050825" or whatever I have formatted it as. My problem started after I installed Tiger (OS 10.4) over the weekend. Now all the format has changed. I've tried to change between the formatting on Excel, chedked the preferences as well as changing the System Preferences. But I just can't get back to what I used to get in the date format. The cell will display whatever I format and that's not a problem. Where the real problem is where I enter the date. If I enter it like I've always been; "5-8-28". Instead of getting "2005-08-28", I'd get May, 8, 2028. The only way to get around this would be if I change the way I enter the date to "month/day/year". But I've been entering date my way for years, and I definitely don't want to have to change now. So is there anyway to change this. so it will accept the date as the way I enter it as "year-month-day". Thanks for any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) |