View Single Post
  #34   Report Post  
Posted to microsoft.public.excel.programming
[email protected] iumarabbas@gmail.com is offline
external usenet poster
 
Posts: 1
Default Formatting date as first letter of day only

On Thursday, December 16, 2010 11:42:22 AM UTC+5, GavinS wrote:
In various cells I have dates written in as dd/mm/yy format.

I would like to format this as d - that is the first of the day only.
For example 16/12/10 displayed as T (for Thursday).

How can I do this please


USE THIS CODE:

string stTodayDayFirstLetter = DateTime.Now.ToString("ddd").Substring(0, 1);