Question about Microsoft Office Standard for PC

1 Answer

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

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 26 Answers
Re: How to change the date format?

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

0 characters

Uploading: 0%


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


3 Points

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

SQL query to change date and/or time format

The function you're probably looking for is CONVERT. Here's an example (101 applies the format "mm/dd/yyyy", 108 applies "hh:nn:ss"):

SELECT CONVERT(varchar(10),getdate(),101) as JustDate, CONVERT(varchar(8), getdate(), 108) as JustTime


JustDate JustTime
---------- --------
09/24/2013 13:13:56

(1 row(s) affected)

Jul 15, 2013 | Microsoft SQL Server 2005 Standard Edition

1 Answer

Set date format

Hi Erez,

This info is from

You can easily change the language and formats.

Windows: edit openproj.bat

add the following to the java command line

-Duser.language=en -Duser.region=GB

for UK format. Use any legal combination, e.g., fr and CA for French in Canada, or en and AU for Australian English. This will change both your language and locale formats (dates and times).

On Unixy systems, change in the same way.

Mac user instructions are provided at this site as well.

Good luck.

Jan 17, 2012 | Projity OpenProj

1 Answer

Have this date 2004.04.01 and would like to change

In the cells/columns/rows you want to show that way, highlight them, and then right-click in them and select Format Cells.

When the window opens, on the left side select Date, and then on the right side select the format you prefer.

Thanks for using Fixya.

Jul 10, 2009 | Microsoft Office Excel 2007

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


populate the field's controlsource with =forms.formname.field and then from the properties of the new field change the format to a required one, on saving it will use that format.

Dec 07, 2007 | Microsoft Office Professional 2007 Full...

2 Answers

Conversion from date to text formet

Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.

Nov 18, 2007 | Business & Productivity Software

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,277 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides