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

1 Answer

CNewton2

Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.
Contributor
27 Answers

Select the cell or column or range containing the date(s). Click Format -> Cells On the Number tab, click Date This will give you the various formats available. The default date format is determined by the settings in the control panel. Windos XP: Control Panerl -> Date, Time, Language and Regional Options -> Change the format of numbers, dates, and times -> Customize This dialog box has tabs for Numbers, Currency, Time, and Date. There you can select the default formats for how you want things to appear. Hope this helps.

Posted on Sep 08, 2007

Add Your Answer

Upload

Upload an image from your computer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

Loading...

Include an image. It's worth a thousand words.

prev next

Related Questions:

0helpful

1answer

Quickbooks point of sale date format

According to Intuit QuickBooks formats dates the same way that Windows does. To change the format of dates in QuickBooks, change your settings in Windows you are using. For more help in changing date format in window's follow Intuit Support .

Read full answer

Apr 01, 2014 • Intuit QuickBooks Point of Sale Pro...

0helpful

1answer

How do I change the time on Pantech Swift?

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.

Read full answer

Mar 10, 2013 • Pantech Swift Mobile Phone - Purple at&t

0helpful

1answer

How do I change the time on the clock?

Tap Menu > Settings > Phone
Tap Time & Date.
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

Read full answer

Mar 14, 2011 • Pantech Pursuit P9020

0helpful

1answer

How do I change the date and time on my Meridian Business Set M5316?

To Change the Date and Time:

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

To Change the Display Fomat:

Press
Press the volume key until "Time and Date Format?" is shown on the display
Press
Press the volume key until the desired format is shown on the display
Press to save the new setting
Press or to exit the programming mode

Read full answer

Nov 16, 2010 • Cell Phones

0helpful

1answer

How do I change the date format in quick books? I

ou an change the date format in preferences.

Read full answer

Feb 18, 2010 • Intuit QuickBooks Premier: Accountant...

1helpful

1answer

MY DESKTOP TIME IS IN 24 HR FORMAT

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!!

Read full answer

Aug 02, 2009 • Computers & Internet

0helpful

1answer

Changing dates format in a spreadsheet

i want professional office 2007 product key

Read full answer

Mar 29, 2009 • Microsoft Office Excel 2003 for PC

35helpful

1answer

Set the time and date on a canon mp25dv/instructions

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.

Read full answer

Feb 26, 2009 • Canon MP-25DV Calculator

0helpful

1answer

Unable to Change Dates

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.

Read full answer

Jun 27, 2008 • Excel (SS8SATAS5128400R)

0helpful

1answer

Date format in quickbooks 7.4

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.

Read full answer

Nov 15, 2007 • Intuit QuickBooks Premier: Accountant...