Thread: Date Formatting
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
bodhisatvaofboogie bodhisatvaofboogie is offline
external usenet poster
 
Posts: 93
Default Date Formatting

THanks for all the speedy results...NOW one step further can I make the date
Bold? and How do I do that?

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


THANKS AGAIN!!!
"Rick Rothstein (MVP - VB)" wrote:

Try this...

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

Rick


"bodhisatvaofboogie" wrote in
message ...
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!!!