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