Date Format from simple date data in numbers

Occasional Contributor

Hi All,

Can you please help me with following, I have data in number format like 24112020 and I want it to be 24-Nov-2020. If I am changing simple date format and I am getting ###########. So any best and easy way?

 

App Prod DateDate (I want)
2411202024-Nov-2020
2412202024-Dec-2020
2410202024-Oct-2020
0 Replies