LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Formatting date as first letter of day only

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DATE() Month in Letter NOT Number Neon520 Excel Worksheet Functions 23 January 15th 08 07:41 PM
date in Excel displays incorrectly when merged in letter Feather 52 Excel Discussion (Misc queries) 1 March 13th 06 10:36 PM
Number zero and the Letter O formatting [email protected] Excel Programming 2 March 16th 05 11:24 AM
press letter and go 2 entry begin w letter in data validation drop MCP Excel Programming 1 August 28th 04 05:07 PM
Find out from a date if it is a red letter day or not Abdul Salam Excel Programming 0 July 16th 03 11:19 AM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"