CF1LetterDay.xlsx

<div>
<div class="content wysiwyg-content">
The custom number format ddd shows a 3-character day name and dddd shows the full day name. I would like to show the day-name as a single character using conditional formatting only. I know I can do it using a combination of TEXT and LEFT but I am looking for conditional formatting.
</div>
</div>


The custom number format ddd shows a 3-character day name and dddd shows the full day name. I would like to show the day-name as a single character using conditional formatting only. I know I can do it using a combination of TEXT and LEFT but I am looking for conditional formatting.

Custom format to show single-character day name

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.