View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Lincoln Mark Lincoln is offline
external usenet poster
 
Posts: 227
Default display unabbreviated month in text, from system date?

Put =NOW() into the cell in question. Set the formatting in the cell
to "mmmm" (no quotes).

Mark Lincoln

On Oct 2, 2:14 pm, JustSomeGuy
wrote:
How would one write a formula to enable a cell in a workbook to always
display the current month, in text format, unabbreviated, just by parsing the
system date - no input required from the user?