<div>
So long as it is a true Date Time stamp rather than text you can just apply Date formatting to it. If you don't have dd/mm/yyyy as one of your standard formats you will have to create a custom format.
</div>


<div>
Try to choose "Custom" as category, for Cell property, and put format "DD-MM-YYYY".<br><br><br>
</div>


Sam OZ

<div>
<div class="content wysiwyg-content fr-view">
I have an excel extract .&nbsp; one field is date&nbsp;<br>Sample entries are &nbsp;( it is mm/dd/yyyy format) <br>&nbsp;<table style="margin-left: calc(6%); width: 94%;"><tbody><tr><td>5/23/2019 2:47:10 PM</td></tr><tr><td>5/27/2019 10:54:43 AM</td></tr><tr><td>5/28/2019 6:30:35 AM</td></tr><tr><td>5/28/2019 6:49:34 AM</td></tr><tr><td><br></td></tr><tr><td><br></td></tr></tbody></table>How can I get &nbsp;it formatted to show the display as below<br>23/5/2019<br>27/5/2019<br>28/5/2019<br>28/5/2019
</div>
</div>



I have an excel extract .  one field is date 
Sample entries are  ( it is mm/dd/yyyy format)
 
5/23/2019 2:47:10 PM
5/27/2019 10:54:43 AM
5/28/2019 6:30:35 AM
5/28/2019 6:49:34 AM
How can I get  it formatted to show the display as below
23/5/2019
27/5/2019
28/5/2019
28/5/2019


So long as it is a true Date Time stamp rather than text you can just apply Date formatting to it. If you don&#39;t have dd/mm/yyyy as one of your standard formats you will have to create a custom format.


Try to choose &quot;Custom&quot; as category, for Cell property, and put format &quot;DD-MM-YYYY&quot;.

excel formatting of date

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 Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.