How to change the date format? - Microsoft Office Standard for PC

Setting the time & date

1. Tap Menu; > Settings > Phone.
2. Tap Time & Date.
3. Change Time, Time Format, Date, Date Format or Auto Update > Save.

1. Tap Menu > Settings > Phone
2. Tap Time & Date.
3. Tap Time Format, Date Format or Auto Update > Save

It's best to keep it set to Auto Update so that it takes the network time and updates for DST changes.

Hope this helps. If so, please consider rating this solution.

-best regards,
M

Error 6 indicated an invalid date, such as a month greater than 12 or a day greater than 31.

The calculator has two different formats for dates: DD-MM-YYYY and MM-DD-YYYY. To see the current format, press 2nd [FORMAT] down-arrow down-arrow. To change the format, press 2nd [SET]. Press 2nd [QUIT] to exit.

To Change the Date and Time:

1. Press
2. Press the volume key until "Time and Date Set?" is shown on the display
3. Press
4. Enter the date using the format shown on the display (DDMMYY)
5. Enter the current time based on the 24-hour clock
6. Press to save the new time and date settings
7. Press or to exit the programming mode

To Change the Display Fomat:

1. Press
2. Press the volume key until "Time and Date Format?" is shown on the display
3. Press
4. Press the volume key until the desired format is shown on the display
5. Press to save the new setting
6. Press or to exit the programming mode

ou an change the date format in preferences.

Hi,

START->CONTROL PANEL->DATE,TIME,LANGUAGE.....->Change format of numbers,dates and time. Under regional and language option click customize option and select time tab under customize regional options . There would be an option to change date, time change format. Click that and it would fix the issue.

Hope i helped you.

Thanks for using ' Fixya ' and have a nice day!!

i want professional office 2007 product key

To set date:
1. Press the calendar/clock button (display should show date)
2. Press and hold the 'time set' button for 3 seconds (first digit of the date should flash)
3. Use the numeric keys to enter date using mmddyyyy format
4. Press 'time set' button

To set time:
1. Press the calendar/clock button twice (display should show time)
2. Press and hold the 'time set' button for 3 seconds (first digit of the time should flash)
3. Use the numeric keys to enter time using hhmm format, press 'AM/PM' button as needed
4. Press 'time set' button

The '12/24' button changes between 12 hour and 24 hour format for time.
The 'format' button changes the date format from mmddyyyy to ddmmyyyy or yyyymmdd.

Hi,
I am using MS-2007, i got the solution upto some level only.
i can't say exactly whether it is right or not.
my solution is :

first change the settings in ControlPanel/Regional and Language Options.
Click on Customize button/open the Date Tab and set the date format there.
and then proceed with CSV.
Open CSV in Excel and divide Text to coloumns.
Ur all Date Cells will be in particual Format.
and Select that coloumns and right click Format Celss....etc.
Thanking u.

If u found any Douts, Suggestions ,Plzz let me know.

If it's anything like Excel, someplace in the FORMAT menu should be options to allow you to change the date format. (Block off the cells, row, or column in question, click FORMAT in your toolbar.) You may have different country options or formatting choices within the date type.