Date Format: Entering Date as 121214 but want excel displays as 12/12/2014

[Warmhearted]

Hello Helpers:

I want to enter a date as 121214 on cell but want excel displays it as 12/12/2014. Please help me how to format it. Thanks.

Brando

 

[mfexcel]

for your reference:
Convert an 8-digit number into Excel-recognizable Date | wmfexcel