Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi~
I am having trouble with excel changing the format of how I am wishing to enter the dates. I am entering the dates one of two ways: The first is Season/year (ie. Fall 1999), the second is Month/year (ie. March 1999). Excel doesn't change the season/year on me, but it does change the month/year date into a month/day/year format, and one that is totally off. It gives me something like 06/01/1905 when I type in March 1999. Any suggestions on how I might remedy this problem and get Excel to not change what and how I have enter the dates would be most appreciated. Thanks, Arron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date formatting in Excel | Excel Discussion (Misc queries) | |||
Date Formatting in Excel Urgent | Excel Discussion (Misc queries) | |||
date formatting in excel | Excel Worksheet Functions | |||
Formatting the Date in Excel | Excel Discussion (Misc queries) | |||
Date formatting in Excel | Excel Discussion (Misc queries) |