Thread: how format date with TEXT() function for international usage?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
  
Posts: 434
Default how format date with TEXT() function for international usage?
hi, Alex !

you might want to give a try to an (ancient ?) xl4 macrofunction through a defined name-formula (i.e.)

name: MonthText
formula: =rept(index(get.workspace(37),20),4)

and then... =TEXT(DATE(2009,4,1),MonthText)

hth,
hector.

__ OP __
=TEXT(DATE(2009,4,1),"mmmm") doesn't work for different locales.
This one is done for english based locale, but will not work for russian because format is different - "мммм".
So I can make a document, but nobody with different locale can read it!!!
How to specify format internationally and people with different locales can read document and see how functions work?


Reply With QuoteReply With Quote