project server training consulting - Date format

Resolved · Low Priority · Version Standard

Mon 15 Oct 2007, 16:09 Delegate Anja said...

Anja has attended:
Project Intro Intermediate course

Date format

Can you change the date format to US format (MM/DD/YR)?

Tue 16 Oct 2007, 13:22 Edited on Tue 16 Oct 2007, 13:37 Trainer Sandy said...

RE: date format

Hi Anja

Select the date on your worksheet e.g. 16/10/07
Choose Format, Cells
Choose Date Category
Change Locale (Location) to USA
Choose 3/14/01 - which is really 14th March 01

If you need this format saved in your workbook
Choose Format, Cells
Category: Choose Custom
Type in the right column: mm/dd/yy for 10/16/07
or: mm/dd/yyyy for 10/16/2007

Hope this helps
Sandy

APOLOGIES Anja - just realised you are asking about Project and not EXCEL

Training courses

	98.7 % recommend us
	More live stats...

Training information:

MS Project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips