Thread: Date Formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Date Formatting

On Fri, 7 Mar 2008 06:54:04 -0800, bodhisatvaofboogie
wrote:

I want to make this the Alpha Month instead of Numeric. For example

CStr(Month(Now)

This will give a result of the number 3

This is being used in the following way:

strbody = "text " & CStr(Month(Now) & " text"

Any help is appreciated. Thanks!!!



strbody = "text " & Format(Now(), "mmmm") & " text"

--ron