Microsoft Excel

warning: Creating default object from empty value in /home/ddm/public_html/modules/taxonomy/ on line 33.

Using Text to Columns to Separate Text in Excel

I found myself with a conundrum when trying to fix dates so they could be imported correctly into a database.  The existing database was exporting dates like this “1943-08-24T00:00:00Z” I need the dates in DD/MM/YYYY format.

The first thing I tried was to use the left function to extract the first 10 characters which gets me the date.  However for some reason the left function would not let me change the output to the right date formula. 

Conditional Formatting

Conditional formatting helps you answer specific questions about your data in Excel. You can apply conditional formatting to a cell range, an Excel table, or a PivotTable report. Conditional formatting makes it easy to highlight interesting cells or ranges of cells, emphasize unusual values, and visualize data in different ways.