View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Formatting date as first letter of day only

If you did this, how would you distinguish between Tuesday/Thursday,
or between Saturday/Sunday?

Pete

On Dec 16, 6:42*am, 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