?B?S2V2aW4gTWNDYXJ0bmV5?=
wrote in :
="Month :- " & TEXT($A$2,"MMMM YYYY")
change this to
="Month :- " & TEXT($A$2,REPT(MONTHCHAR(),4)&" "&REPT(YEARCHAR(),4))
then write the
vb functions MONTHCHAR and YEARCHAR:
Function MONTHCHAR() as String
MonthCHar = Application.International(xlMonthCode)
End Function
Function YEARCHAR() as String
YearChar = Application.International(xlYearCode)
End Function
--
My email address has an extra @ (spell it out) and an extra invalid. Please
remove them if you are not a spammer or list broker and want to reply.