How to Align Date Format

[Dhinakaran]

Hi All,

First up, I'm new to this Forum and the same as with excel.

I've been trying to prepare a data over my work where I've downloaded the raw data from our database for the past 6 months in which the date is in m/d/yyyy format due to which when i prepare a pivot the data is not accurate as there seems to be some miss match with date.

Can anyone help me on how to change the date format to d/m/yyyy.

Current date format : 03-01-2018

 

[alansidman]

Highlight the column of Dates (if they are in fact dates and not text). On the ribbon, Home-->Number-->Date and then select the format you desire in the right hand window.

If they are text you will need to convert them to Dates. You will need a helper column and will need to use a formula in the helper column. See tutorial below

http://www.excelfunctions.net/convert-text-to-date.html