Enter 081817 and see 08/18/17 date

[Bill R]

Type 6 date numbers and have 2 "/" inserted. Custom formatting ##/##/## or 00/00/00 doesn't work. Thanks

 

[Rick Rothstein]

Type 6 date numbers and have 2 "/" inserted. Custom formatting ##/##/## or 00/00/00 doesn't work.

Try this Custom Format...

00\/00\/00

 

[Bill R]

Try this Custom Format...

00\/00\/00

Thank you! Looks like 00"/"00"/"00 works also (I was forgetting the " ").