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

Warmhearted

Board Regular
Joined
Nov 17, 2012
Messages
57
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
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,114,032
Messages
5,545,629
Members
410,696
Latest member
JTrehan
Top