date in the form of yyyymmdd

[kang]

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 #.

 

[Niek Otten]

Look here:

http://xldynamic.com/source/xld.QDEDownload.html

or here:

http://www.cpearson.com/excel/DateTimeEntry.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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 #.

 

[Soundar]

Hi,

You can check various in build date formats in Excel in the following menu,
otherwise you can customize too.

Format-> cells-> caterogy->date.

Hope this will clear your doubt.

Regards,
Soundar.