Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Spanish Functions (Excel 2003)

    Hello Excel gurus,

    One of our users received a file from a client where most of the file was in Spanish. When we open the file initially, it shows values in all the cells, but if we press F9 #NAME errors appear throughout the model, which is very large. So far we have found that the Spanish function Fecha.Mes is EDATE, Redond.Mult is MROUND, and Tasa.Normal is Nominal. While replacing these strings did clear up some of the #NAME errors, we still have thousands of them. So what I'm wondering is, does anyone know of a utility that will take a file created in Spanish and open it in an English version of Excel?

    As always I am thankful for your knowledge and in your debt...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Spanish Functions (Excel 2003)

    Try the free add-in Analysis ToolPak Translator.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Spanish Functions (Excel 2003)

    Hi Hans,

    That utility looks like it might be a winner. I won't know until I get permission to use it here (they are quite security-minded here).

    I'll let you know. As always, thank you for your prompt and really valuable reply...

Posting Permissions

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