View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tjsmags tjsmags is offline
external usenet poster
 
Posts: 21
Default Can I create my own date showing day of week plus date?

I would like to enter the date, such as 10/04/09, and have it show up in the
cell as:
Sun 10/04/09

Is this possible? Right now all I see for formatting the date showing the
day of the week shows: Sunday, October 4, 2009 (it's spelling out too much
for me...I want everything abbreviated).

I would like only the first 3 characters for the day of the week and then
the date using numbers as xx/xx/xx.
--
Thank you.