View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?