Thread: how to dispaly date as Mon 2 Dec
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how to dispaly date as Mon 2 Dec
You could just use a custom format:
ddd d mmm



Simon Le Page wrote:

Hello,
I need to create a forumula to change the date format from 2/12 to display
the day & date "Mon 2 Dec"
Thank You

--

Dave Peterson
Reply With QuoteReply With Quote