98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Project Training and help » project server training consulting - Date format
project server training consulting - Date format
Resolved · Low Priority · Version Standard
Mon 15 Oct 2007, 16:09Delegate 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:37Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Keep constraining dates to a minimumAs 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. |
