other than entering 'yyyy-mm-dd' as date,
are there ways to enter dates "yyymmdd"

if I enter, for example, 20070101 and change the cell format to yyyymmdd
and the cell becomes lots of #.