Thread: Change Dates to 01 of Month
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
FIRSTROUNDKO via OfficeKB.com FIRSTROUNDKO via OfficeKB.com is offline
external usenet poster
  
Posts: 65
Default Change Dates to 01 of Month
Hi,

I am working in the UK date format dd/mm/yy. I am tring to sort by Month and
Year, However many of my dates are not the first of the month. Whilst I can
change the display format as mm/yy. This does not effect the sorting.


before

01/02/06
05/02/06
06/05/06

After


01/02/06
01/02/06
01/05/06


Thanks in advance

--
Message posted via http://www.officekb.com
Reply With QuoteReply With Quote