Is there a way in Excel 2007 version to convert from English into other languages?
Currently I have a page with columns in English, German, Italian, French, Spanish, Brazilian Portugese, Finnish, Norwegian, Swedish. I just use index + match to look up the correct column when a user click on a pull down menu to pick his/her local language to work on a form. paying for translation can be quite expensive.
And on the 2010 (I'm not using it currently so I don't know how it works) version, would the whole worksheet get translated into a foreign language, or can the workbook creater specify only certain cells to be translated? Sometimes, you may have a different product name in a different country and direct translation may not be the right way to do so.