?
Solved

Custom format to show single-character day name

Posted on 2014-01-06
1
Medium Priority
?
287 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

718 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