Others

How to Set Date Formats and Currencies per Microsoft Project Plan

Natalie Taylor Oct 15, 2026 868 views

Question details

The user needs to configure specific date formats (e.g., DD/MM/YY), currencies, and time zones for individual project plans without altering the global Windows system date format.

How to Set Date Formats and Currencies per Microsoft Project Plan

Product: Microsoft Project
Device & OS: Windows
Scenario: Managing international projects across different regions (e.g., US and Europe) via PWA and Teams, while keeping the application language in English.
Observed behavior: Project-level currency settings work properly, but changing the Office display language to English (UK) does not override the system-wide Windows date format, leaving dates in MM/DD/YY instead of the desired DD/MM/YY format.

Before you start

Ensure you have your Microsoft Project file open in the desktop client and verify whether your organization enforces standard calendar templates or strict regional policies through Project Web App (PWA).

Solution 1Recommended

Adjust Built-in Project Display and General Options

Use this method to apply project-level currency settings and adjust the default date format natively within the Microsoft Project options.

Microsoft Project allows you to customize the currency per project plan natively. However, while you can select a different layout for dates, the underlying format structure (like MM/DD vs DD/MM) often depends heavily on Windows regional settings. Selecting a predefined layout without changing your OS settings is the safest first step.

Access Project Options

With your project plan open, click on the 'File' tab in the top-left corner of the ribbon, then select 'Options' at the bottom of the menu.

Change the Date Format

In the Project Options dialog, select the 'General' tab. Look for the 'Project view' section, click the 'Date format' dropdown, and choose a layout that best matches your preferred DD/MM/YY or international format. Click 'OK' to apply.

Set the Project Currency

To adjust the currency, return to 'File' > 'Options' and select the 'Display' tab. Under the 'Currency options for this project' section, select your target currency from the dropdown (e.g., GBP or EUR). This applies only to the current project file.

Adjust Built-in Project Display and General Options

Windows Regional Settings Dependency: If the specific DD/MM/YY format you need is not available in the 'Date format' dropdown, it is because Microsoft Project pulls these structures directly from your Windows Regional Settings. Changing the Office language pack will not resolve this.

Solution 2

Use Custom Fields to Override Date Display

If the native date formats rely too strictly on your global Windows settings, use custom text fields with formulas to force a specific date format.

Free Microsoft Office alternative

Manage Your Project Timelines with WPS Office Spreadsheets

Microsoft Project's deep dependency on Windows regional settings can make international date formatting frustrating. As an alternative, WPS Spreadsheet offers a free, lightweight solution to manage project timelines, build Gantt charts, and apply customized date formats or currencies to individual cells effortlessly, without relying on global OS configurations.

1. Open WPS Spreadsheet: Launch WPS Office and create a new Spreadsheet to act as your project tracker or Gantt chart.
2. Format Project Dates Freely: Select the cells containing your dates, right-click, choose 'Format Cells', and define your exact preferred localized date format (like DD/MM/YY).
3. Customize Currency Options: Highlight cost columns, access 'Format Cells', and apply specific regional currencies independent of your operating system settings.

Free, lightweight, and user-friendly Office suiteFully compatible with Microsoft Excel (.xlsx) formatsCustomize date formats (DD/MM/YY) independently of system settingsFamiliar interface for seamless project data migration

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't adding a new language pack to Office change my date format in Microsoft Project?

Microsoft Project generates its default date structures based on your Windows Regional Settings, rather than the Microsoft Office display language. Changing the language pack updates the user interface text but does not override the underlying operating system date configurations.

Can I apply multiple different currencies in a single Microsoft Project plan?

No, Microsoft Project natively supports only one currency per project file. If you are managing a global project that requires multiple currencies, you must use custom number fields and apply formulas with static exchange rates to calculate and display the converted costs.

How do I handle different time zones for global project teams?

While you cannot set a specific 'time zone' attribute per task in Project, you can create and assign different Base Calendars for specific resources or tasks. By defining customized working hours within these calendars, you can simulate the exact required global time zones for accurate scheduling.

Office Quick Solutions