<div>
How to check that ?<br />
<br />
The server regional setting is set to English (Australia)
</div>


<div>
<div class="content wysiwyg-content">
People,<br />
<br />
Can anyone here please suggest me what can be done to make sure the exported data from the SharePoint 2010 site below:<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/01_w02/1066383/SP.png" target="_blank" title="SharePoint Site (81 KB)"><img alt="SharePoint Site" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/01_w02/800_1066383/SP.png" /></a><br />
To the Excel format doesn't truncate or change the date column like in the below red squared column ?<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/01_w02/1066384/EXCEL.png" target="_blank" title="Excel exported data (205 KB)"><img alt="Excel exported data" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/01_w02/800_1066384/EXCEL.png" /></a><br />
Thanks in advance
</div>
</div>


SP.png

EXCEL.png

People,

Can anyone here please suggest me what can be done to make sure the exported data from the SharePoint 2010 site below:



To the Excel format doesn't truncate or change the date column like in the below red squared column ?



Thanks in advance

Exported data from SharePoint 2010 to Excel issue  ?

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.