• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

Custom format to show single-character day name

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.
0
Saqib Husain, Syed
Asked:
Saqib Husain, Syed
1 Solution
 
Rgonzo1971Commented:
Hi,

you have to make a serie of CF

like =WEEKDAY(E2)=1
=WEEKDAY(E2)=2

and use a custom format Format Number Custom and enter the corresponding Letter for each rule

like this "N", "M", ",T", ...

EDIT See example
Regards
CF1LetterDay.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now