Microsoft Office Standard for PC Logo

Related Topics:

Question about Microsoft Office Standard for PC

1 Answer

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

Posted by sappani on

Ad

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

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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

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,318 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13435 Answers

David Shaub

Level 3 Expert

2994 Answers

Mehandi Husain ...

Level 3 Expert

1654 Answers

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

Answer questions

Manuals & User Guides

Loading...