View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shriil shriil is offline
external usenet poster
 
Posts: 37
Default How to custom format a date

Hi

I would like to custom format a date through a formula such that the
following dates can be formatted
as mentioned below

1-Sep-11 : 1st September 2011

2- Sep-11 : 2nd September 2011

3- Sep -11 : 3rd September 2011

4-Sep-11 : 4th September 2011

The "st", "nd", "rd" & "th" needs also to be superscripted with the
Day number.

Thanks for any ideas!