Microsoft Office Standard for PC Logo

Related Topics:

Posted on Sep 08, 2007

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
  • Posted on Sep 08, 2007
CNewton2
Contributor
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.

Joined: Aug 21, 2007
Answers
27
Questions
0
Helped
14115
Points
34

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.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

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.
0helpful
1answer

How do I change the time on the clock?

  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
0helpful
1answer

I'm not understanding how to change the date in the date worksheet on the BAII. When I enter the numbers and (enter), I get and error 6. Any suggestions on what I'm doing wrong?

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.
0helpful
1answer

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

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
Nov 16, 2010 • Cell Phones
0helpful
1answer
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!!
0helpful
1answer

Changing dates format in a spreadsheet

i want professional office 2007 product key
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.
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.
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.
Not finding what you are looking for?

1,328 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...