Hi All,

i'm currently trying to convert 12/18/2015 into 2015-12-18 using the text() formula.

currently cell DI73 is populated with 12/18/2015
1. therefore i use the formula, =TEXT(DI73,"yyyy-mm-dd") but i still get 12/18/2015.

2. i also tried changing the format manually as shown in the attachment, but still unable to change the format.

date issue.png

3. i also ensured that the computer date format is also in yyyy-mm-dd format, but still nothing works.

i am really stuck here.