Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Country Codes In Formula?? (xp-pro - office 2003)

    hi again...

    a co-worker just came up with the following formula:

    =TEXT(38763,"[$-"&972&"] MMMM")

    and expected the name of the month to be displayed in hebrew, because of the country code used...

    i have never ever heard about such a thing that you can turn a formula like that into any language....

    please advise...thank you..

    best,
    wolfgang

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Country Codes In Formula?? (xp-pro - office 2003)

    AFAIK the only way to do this is to change your regional settings in Control Panel.

    The technique listed is used to "lock" a currency as a particular type so that it will be currency and not changed by regional settings. If you set the currency in excel now the symbol will change as the regional settings change. Using the "trick" you mentioned (but including the other symbol) locks it on that symbol so it will not change when the regional setting is changed.

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Nov 2004
    Location
    Darmstadt, Hessen, Germany
    Posts
    128
    Thanks
    15
    Thanked 2 Times in 2 Posts

    Re: Country Codes In Formula?? (xp-pro - office 2003)

    good morning steve...

    thank you very much for your education....

    "you'll learn something new every day", so they say...

    best,
    wolfgang

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •