Thread: Formatting date as first letter of day only
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
  
Posts: 703
Default Formatting date as first letter of day only
If you can do with two lettes, it is no problem.

Format Custom Type: ddd

Regards,
Per

On 16 Dec., 07:42, 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

Reply With QuoteReply With Quote