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?
|