Date format

[22strider]

Hello,

How can I convert data that is in Date format "dd/mm/yyyy" to Date format "mm/dd/yyyy". For example I need to convert 01/02/2022 (February 1, 2022) to 02/01/2022.

I have tried options given in Excel format menu but they did not work.

Regards,
Rajesh

 

[jasonb75]

If formatting doesn't work then it suggests that the original dates are not valid.

Try selecting the dates, then going to the Data tab on the excel ribbon. Choose Text To Columns.
Click Next twice, then change the date dropdown to DMY and click Finish.

Now when you change the format it should work. If it does not then there could be another problem with the original dates such as hidden characters that prevent them from being converted properly.

 

[BSALV]

is your dateformat a real string or a number in numberformat "dd/mm/yyyy".
In that 2nd case, you only have to change the numberformat.