date in the form of yyyymmdd

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kang - 08 Oct 2007 06:56 GMT

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

Reply to this Message

Niek Otten - 08 Oct 2007 10:13 GMT

Look here:

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

or here:

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

Signature

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

Reply to this Message

Soundar - 11 Oct 2007 17:19 GMT

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.

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

Reply to this Message