Thread: Date Problem

Hello All ,

Excel 2007 spreadsheets on my computer is acting strange since sometime now.
I expect dates to appear as 5-Mar-10 , when I enter 5/3 , however it appears as 3-May-10.

I did go to format cells and changed the format , yet I failed to change.

Thanks in advance.

I followed your suggestion , however change in regional settings did'nt work for me.