View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BillG BillG is offline
external usenet poster
 
Posts: 5
Default Display only first letter of Weekday in number format

When formatting a date, I would like to display only the first letter
of the weekday. For example, 9/1/08 (39692) would display as "M". I
know format "ddd" will display "Mon", but I'd like to have *only* the
first letter.... Any ideas?

I am using Excel 2007.

Thank you!