By 'reversing it' do you mean it is treating the month as the days and the
days as the month?

Try checking the Regional Settings under Control panel. It may be that
something has knocked your settings from English (United States) to somehting
else, causing Excel to interpret your input differently.


"Diana" wrote:

i work in excel everyday, today i was putting in the date where i always put
my dates and its reversing it. anyone have any ideas? i have unstalled and
reinstalled the software thinking that would help. thank you.