There's no way for a macro to know how you typed it in unless you cell
the number format to Text.

Otherwise, XL's parser automatically interprets the entry as a date and
converts it to a long integer before any event fires that could trigger
a macro.



In article ,
JOSEPH WEBER wrote:

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.