change data format in visio pro 2.0

Question

change data format in visio pro 2.0. Currently 1/3 instead of 3/1 for march 1

Answer 1

Hi @Stephen Lagano, 

Thank you for reaching out and for clearly describing how the date is currently being presented in your drawing. 

Based on the details that you would like to change the date format in Visio Professional 2.0 so that March 1 is displayed as 3/1 instead of 1/3.  

This behavior occurs because Microsoft Visio follows the regional date settings configured in Windows as well as the formatting rules applied to Shape Data properties within the diagram. When the system or the shape data field is configured to use a day first format, Visio will automatically interpret and display March 1 as 1/3 instead of 3/1. Therefore, even if the correct date is entered, it may still appear differently depending on the applied regional or property level formatting. 

To ensure that the date format is displayed in the month first format that will suit your situation, please follow these steps: 

1/ Update the Windows regional date format so it aligns with the month day structure.  

• Open Windows Settings, go to Time and Language, then select Region.  
• From there, choose Change data formats and set the Short date to a format that starts with MM.  
• After applying the change, close and reopen Visio so it can recognize the updated system setting.  

2/ Review the date field inside Visio to confirm it is configured correctly.  

• Select the shape that displays the date, open the Data tab, and choose Define Shape Data.  
• Ensure the data type is set to Date, as Visio displays date values using the system short date format when this option is selected.  
• This ensures consistency with the Windows regional settings.  
• Reference: Add data to Visio shapes - Microsoft Support 

3/ Verify the original data source 

• If the date comes from Excel or another linked source, open that file and confirm the date column is formatted as Date with month day order.  
• Save the source file and refresh the data connection in Visio. 
• Reference: Regional settings and formats - Globalization | Microsoft Learn 

This approach will help Visio interpret and display March 1 as 3/1 consistently across your diagram. 

Please feel free to share a screenshot of your Shape Data settings if the format still appears incorrectly, and I will tailor the next steps for you. 

I hope this response has helped address your question and clarify the behavior you're experiencing. Please feel free to reply if you have any further questions, I would be happy to assist further.   

Thank you for your patience and your understanding. I look forward to continuing the conversation.  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.     

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

Visio uses the date format defined in the Windows regional settings. To change from 1/3 (1 March in day/month/year) to 3/1 (March 1 in month/day/year), adjust the system date format:

1. In Windows, open Settings.
2. Go to Time & Language → Region.
3. Under Regional format, choose a region that uses MM/dd/yyyy (for example, English (United States)), or select Change data formats and set the Short date to a pattern starting with MM.
4. Close and restart Visio so it picks up the new system format.

Visio will then display and interpret dates using the new Windows short-date format.

---

References:

• Manipulate the Visio file format programmatically
• May 2019 Japanese Era changes for Visio