Solved

Custom format to show single-character day name

Posted on 2014-01-06
1
253 Views
Last Modified: 2014-01-08
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
Comment
Question by:Saqib Husain, Syed
1 Comment
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39758708
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now