View Single Post
  #1   Report Post  
Malcolm Agingwell
 
Posts: n/a
Default



"dominicb" wrote:


Good afternoon Malcolm Agingwell

Would the date in the format "31 January 2005" be of any use to you?
If so, set up a custom format of dd mmmm yyyy. Excel doesn't handle
ordinals (1st, 2nd, 3rd etc) on its own.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=383071

Thanks this is very close to what's required.