Thread: date in the form of yyyymmdd
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default date in the form of yyyymmdd
Look he

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

or he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"kang" wrote in message ...
| 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 With QuoteReply With Quote