Date and Time Setting in Windows XP

Asked By georgewin 0 points N/A Posted on - 08/15/2011

How can i change date setting of Windows Xp. Actually when i used excel and put any date by the format of Day-month-year the excel automatically changed it into Month-Day-Year. I checked this option in the excel but the format of date in excel was correct as per my need. I also observed that time in task bar was showing without AM and PM. How can i change setting of time and date as per my requirement.

• Status: Open
• Question Views: 1852
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Windows XP

Best Answer by arafat hossain

Go To Solution

Answered By senti 0 points N/A #115538

Date and Time Setting in Windows XP

To change your time setting, go to the right side of your taskbar. Then on the extreme right below you would see the time, so now double click on the time, then the time setting bo will open. Now, on that setting box, on the right side there'll be a clock resemblance watch, so below that you'll see the time adjustment area. so adjust it and then left click once on am/pm, then select up or down on the side of am/pm. this will change the setting and show am/pm on your taskbar too.

Hope your problem has been solved by these solution.

Thanks.

About senti

Questions
0

Answers
5

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 08/15/2011
• Question Category: Windows XP

Answered By Trevor 0 points N/A #115539

Date and Time Setting in Windows XP

Windows XP time settings can be easily changed by double clicking on the date and time on the task tray. When the dialog appears, just move your cursor on the box below the analog clock. Press up and down arrow keys to change the values for hours, minutes, seconds and AM/PM. Then clicking Ok will apply the changes.

Now, to change the format of your time in general, Open your control panel and open the Regional and Language Options, under the General tab you can select the Customize button, and then on the Customized Regional Options under the Time tab, change your Time format based on your desired time format.

About the date and time format in Microsoft Excel you must learn the formatting options. Whatever format your system is, if you change the format in excel, your option will be followed.

 

About Trevor

Questions
2

Answers
315

Best Answers
83

• Vote Up 0 Vote Down

• Posted on - 08/16/2011
• Question Category: Windows XP

Best Answer

Best Answer

Answered By arafat hossain 0 points N/A #115540

Date and Time Setting in Windows XP

Solve

Hello Mr. Georgewin

I read your problem. But I Think this is not a very critical problem. Now I try to give some workable solution for your problem. Please read the below solution and work step by step then I think you will cover up the problem.

 

To change your time setting in windows XP, first you have to go to the right side of the taskbar then double click on the date and time then you see a dialog box. By pressing up and down on the arrow keys you can change the values of hours, minutes, seconds and AM/PM. Then click OK for applying the change.

 

To change the date setting you have to open the control panel and open the Regional and language Option or ‘Change the format of number, date and time’. To change  the date format you have to select the customize button and then Customized Regional Options under the date tab and change your desired date format.

 

Now if you work on MS Excel you can put your date which format you like. So I hope your problem has been solved by these solutions.

Thanks from

Arafat Hossain

About arafat hossain

Questions
0

Answers
20

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 08/16/2011
• Question Category: Windows XP