Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT(Cell1,"MMMM YYYY") to work in all locale.
?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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming | |||
TEXT(Cell1,"MMMM YYYY") to work in all locale. | Excel Programming |