Thread: DATE
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers,microsoft.public.excel
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default DATE
Hi,
Highlight the cell, right click in the mouse, cell format, custom format and
enter

yyyy-mm-dd

"ÎÞÃû" wrote:

Feb 28,2008 --- 2008-2-28
Feb 1,2008 --- 2008-2-1


.

Reply With QuoteReply With Quote