Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cell to get first capital letter?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cell to get first capital letter?
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cell to get first capital letter?
Which version of Excel gives you the result in lower case?
Excel 2003 gives it as Saturday, for example. -- David Biddulph "Patrick Znaty" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cell to get first capital letter?
On Mon, 14 Dec 2009 00:25:01 -0800, 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? No, it cannot be done with cell formatting. It requires an Excel formula, such as: =PROPER(TEXT(A1,"dddd")) --ron |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cell to get first capital letter?
On Mon, 14 Dec 2009 07:49:14 -0500, Ron Rosenfeld
wrote: On Mon, 14 Dec 2009 00:25:01 -0800, 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? No, it cannot be done with cell formatting. It requires an Excel formula, such as: =PROPER(TEXT(A1,"dddd")) --ron My comment that this cannot be done with formatting assumes that, as you wrote, your version of Excel outputs weekdays as lower case. My versions of Excel (since '97 running on the PC under Windows), outputs them all as Proper case, which is what you want. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Capital Letter in a cell | Excel Worksheet Functions | |||
Auto capital letter in a cell | Excel Worksheet Functions | |||
automatic capital letter in a cell | Excel Worksheet Functions | |||
How do I format minuscule word in capital letter one in excell? | Excel Discussion (Misc queries) | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) |