Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TEXT(Cell1,"MMMM YYYY") to work in all locale.
Hi Kevin,
The following funtion works on a computer that has "English" date format setting each YYYY to represent a four digit year, but if view the same workbook on a computer that has "German" settings I don't see a four digit year I only see YYYY. sorry, there's no simple solution. "YYYY" is "hardcoded" in your function and it will not be translated. what you can do: you have a date in A1, in A2 you write your desired textformat eg. MM JJJJ (just type in the text). In A3 use the formula =text(a1, a2) which will give you the correct result. now, you should let the user select his language in a dropdown-menu (forms toolbar). Based on this selection you set the value of A2 to MM JJJJ or MM YYYY or whatever you like. This is what you do for all your hardcoded formats, and in your formulas you refer to the cells like A2. Best regards arno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine text & date formula to show mmmm dd, yyyy? | Excel Worksheet Functions | |||
How to change "xxx CR" and "y,yyy DB" to "+xxx" and "-yyyy" | Excel Worksheet Functions | |||
Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Text(month(now()),"MMMM") deosnt work | Excel Worksheet Functions |