the date format set in my computer is mm/dd/yyyy but i entered date in excel file as 02/09/2010 where 02 is da?

Question

the date format set in my computer is mm/dd/yyyy but i entered date in excel file (thinking the format to be dd/mm/yyyy) as 02/09/2010 where 02 is day 09 is month but due to the format set previously the computer treats 02 as month and 09 as day when i mail this file to other computer with format dd/mm/yyyy the date becomes 09/02/2010 whereas it was 02/09/2010 can i change dates in all excel files as general text.

Answer 1

You can change the default Date formats in the Windows Control Panel.



For Windows 7 (Possibly Vista also):



Go to Start > Control Panel > Clock, Language, Region



Click 'Change keyboard or other input methods'



When the Region and Language window opens, select the appropriate date format.



If you wish to create your own custom format, click 'Additonal Settings' and select the Date tab.



Enter custom formats for Short and Long dates.





For Windows XP:



Go to Start > Control Panel



Click on Date, Time, Language, and Regional Options



Click on 'Change the format of numbers, dates, and times'.



When the Regional and Language Options window appears, click 'Customize'.



Select the Date tab and select the appropriate formats.

Answer 2

I believe control+; is the command to automatically put the date in so you don't have to type it out. You can change how the date appears through your settings.

Answer 3

Why don't you change the format of your system it will completely remove the problem