Date Formatting
Dim s As String
s = Application.WorksheetFunction.Text(Now, "mmmm")
--
Gary''s Student - gsnu200772
"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!!!
|