Question about Microsoft Office Standard for PC

1 Answer

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

Posted by on

Ad

1 Answer

  • 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

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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 .

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

1 Answer

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.

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

1 Answer

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

Mar 14, 2011 | Pantech Pursuit P9020

1 Answer

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

1 Answer

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

Aug 02, 2009 | Computers & Internet

1 Answer

Changing dates format in a spreadsheet


i want professional office 2007 product key

Mar 29, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

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.

Feb 26, 2009 | Canon MP-25DV Calculator

1 Answer

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.

Jun 27, 2008 | Excel (SS8SATAS5128400R)

1 Answer

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.

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

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

1,309 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Scoee Scoffer

Level 2 Expert

162 Answers

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

Answer questions

Manuals & User Guides

Loading...