Thread: How do I sort in English Date format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default How do I sort in English Date format
As long as they are "real" Excel dates, just sort. How they are formatted doesn't matter.
You can check for a cell being a date by formatting as General. Today, Nov 7 2007, is 39393, the number of days since 1-1-1900.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Cavallet" wrote in message ...
|I want to sort a worksheet which has date entered in UK Format ie dd.mm.yy


Reply With QuoteReply With Quote