How to format cell to get first capital letter?
On Mon, 14 Dec 2009 00:54:01 -0800, Ms-Exl-Learner
wrote:
Use Text Function in your weekday formula.
=TEXT(WEEKDAY(A1),"DDDD")
The above function itself will result you the weekdays like this Monday,
Tuesday etc
If you want to show the weekdays in lower case the use the below:-
=LOWER(TEXT(WEEKDAY(A1),"DDDD"))
Result:- monday
If you want to show the weekdays in UPPER CASE the use the below:-
=UPPER(TEXT(WEEKDAY(A1),"DDDD"))
Result:- MONDAY
If you want to show the weekdays in Title Case the use the below:-
=PROPER(TEXT(WEEKDAY(A1),"DDDD"))
Result:- Monday
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"Patrick Znaty" wrote:
I have a column containing weekdays derived from a date using the weekday
function. If I format these cells with "dddd" I will get monday, tuesday etc.
But I want the weekdays to be Monday, Tuesday etc. Anyway to do this as cell
formatting?
In all of your formulas, the WEEKDAY function is superfluous. It happens to
work, but only in the 1900 date system, because the first date in that system
is a Sunday. However, your formula will return incorrect results if one is
using the 1904 date system.
--ron
|