https://forums.autodesk.com/t5/autocad-for-mac-forum/reformatting-data-links/m-p/12693781#M48075 <P>I have linked data from an excel sheet which has all worked well but unfortunately the Date links across as mm/dd/yyyy and I would like it in dd/mm/yyyy format. It is in the dd/mm/yyyy format in the excel document but not AutoCAD?&nbsp;</P> Mon, 08 Apr 2024 10:37:19 GMT liamrobertsSP 2024-04-08T10:37:19Z https://forums.autodesk.com/t5/autocad-for-mac-forum/reformatting-data-links/m-p/12693781#M48075 <P>I have linked data from an excel sheet which has all worked well but unfortunately the Date links across as mm/dd/yyyy and I would like it in dd/mm/yyyy format. It is in the dd/mm/yyyy format in the excel document but not AutoCAD?&nbsp;</P> Mon, 08 Apr 2024 10:37:19 GMT https://forums.autodesk.com/t5/autocad-for-mac-forum/reformatting-data-links/m-p/12693781#M48075 liamrobertsSP 2024-04-08T10:37:19Z https://forums.autodesk.com/t5/autocad-for-mac-forum/reformatting-data-links/m-p/12693945#M48076 <P>Hi&nbsp;<a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/14965594">@liamrobertsSP</a>&nbsp;,</P><P>&nbsp;</P><P>If I use these settings for datalink when I insert it to a drawing:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="2024-04-08_14-56-46.png" style="width: 999px;"><img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1347026iD92CC753C2F8694B/image-size/large?v=v2&amp;px=999" role="button" title="2024-04-08_14-56-46.png" alt="2024-04-08_14-56-46.png" /></span></P><P>&nbsp;</P><P>I get correct results:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="2024-04-08_15-00-53.png" style="width: 999px;"><img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1347027iC7C82D72F6088C1F/image-size/large?v=v2&amp;px=999" role="button" title="2024-04-08_15-00-53.png" alt="2024-04-08_15-00-53.png" /></span></P><P>&nbsp;</P><P>Please pay attention to the note in the "Format cells" dialog in Excel&nbsp;about date formats with *.</P><P>If you select such date formats (with *) in Excel, they <EM>"respond to changes in regional date and time settings that are specified for the operating system."</EM></P> Mon, 08 Apr 2024 12:07:19 GMT https://forums.autodesk.com/t5/autocad-for-mac-forum/reformatting-data-links/m-p/12693945#M48076 maxim_k 2024-04-08T12:07:19Z