View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patrick Znaty Patrick Znaty is offline
external usenet poster
 
Posts: 1
Default 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?