[SOLVED] getting date in desired format

[sunnyujjawal]

I need date in this format
dd-mm-yyyy
01-02-2019

Specially I need zero before date.

[jme1013]

Right Click > Format Cell > Custom >

in the "Type:" field, scroll down to "m/d/yyyy" select it

Once selected, click on "m/d/yyyy" at the top of the field ( right under the word Type: )

change it from "m/d/yyyy" to "mm/dd/yyyy"

[sunnyujjawal]

not getting desired result
it shows mm-dd-yyyy but i need dd-mm-yyyy
only if i select Location English India and Western

[jme1013]

change it to dd-mm-yyyy

[sunnyujjawal]

i got the solution

Attachment 642914

Attachment 642915