I need to know if there is a way to have a spreadsheet format dates
automatically without affecting other cells. For example, in cell a1 or any
other cell, i want to enter "january 09" and have the date stay exactly as i
typed it instead of what Excel does "9-jan". I want it to do this with every
instance of a date in the spreadsheet. I still want to be able to type in
cell a2 a numerical value. Outside of formating a column for a date is there
any way i can get Excel to do this? Please help.