user needs excel formulas translated from italian to english

Hey there,

Several users are needing to translate excel formulas from italian to english.  The file is originally made in english but users' pcs are all in foreign languages.

It's easy to change the pc to a language but it's converting the formulas as well, so they need to be english again.

Would google translator do this?  i'm hesitant to spend 39.00 dollars unless it's defiantely or another free solution ?


Who is Participating?
Ejgil HedegaardCommented:
The formula should translate automatically, so use replace Ctrl+H to change the formatting string in the formulas.
That's how I do it.
Have you tried Options > Language > Choose Display Language.
Then add English and set Excel to display in English?

I doubt that Google Translate will do the job.
Saurabh Singh TeotiaCommented:
You can perhaps use this to do what you are looking for..

Another Source which you can use..

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Ejgil HedegaardCommented:
Why do you need this.
Excel automatically change formulas to local language.
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
That is you type in your localized formulas, and they will get displayed in the current language. You only need to care if formulas are assembled from strings, like in VBA.
Ejgil HedegaardCommented:
Or if you have formulas setting date and time formats.
The format string is not translated when the workbook is opened in another language.
metalfubarAuthor Commented:
yes i have formulas with date, time and settings etc...that get translated into from english to italian.  this is what's breaking.

QlemoBatchelor, Developer and EE Topic AdvisorCommented:
You could have VBA doing that ^^^ on demand, e.g. before saving.
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.