Technical forums » Office applications »
change language of formulas in Excel
Thread poster: bendksu
bendksu
bendksu  Identity Verified
Thailand
Local time: 03:47
Member (2011)
Danish to English
+ ...
Dec 6, 2014

I have an Excel spreadsheet that has graphs and formulas.

The output of the formula is in Danish, but I need this to be English.

Does anyone know how I change the output of the formula to be English?

For example, the formula is:

=TEKST(H3;"Mmmm åååå")

and H3 is:

01-01-2013

So the outcome of the formula is:

Januar 2013

But I want it to be:

January 2013

... See more
I have an Excel spreadsheet that has graphs and formulas.

The output of the formula is in Danish, but I need this to be English.

Does anyone know how I change the output of the formula to be English?

For example, the formula is:

=TEKST(H3;"Mmmm åååå")

and H3 is:

01-01-2013

So the outcome of the formula is:

Januar 2013

But I want it to be:

January 2013



Any help would be appreciated.

Thanks. ▲ Collapse
 
Tony M
Tony M
France
Local time: 03:47
Member
French to English
+ ...
SITE LOCALIZER
For dates specifically Dec 6, 2014

If you go to Format > Cells, and set the cell contents format to 'Date', you get a little dropdown box that lets you set the 'region' — which in fact sets the language in which the dates will be expressed.

I'm not sure how 'language' applies to any other formula results, dates are the only ones I can think of where a formula will return a number converted to any form of text.

[Modifié le 2014-12-06 08:03 GMT]
 
EvaVer (X)
EvaVer (X)  Identity Verified
Local time: 03:47
Czech to French
+ ...
I think formulas adapt to the environment Dec 6, 2014

They will just be translated automatically when you open the file on a computer where the target language is set as the system language. At least, that is what happened to my accounting system in Excel - I used to have an "English" computer, then I got a new computer, my IT technician automatically set my system language to Czech, transferred my files to the new computer - and my old formulas now appear in Czech (as a result, I don't understand them).
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

You can also contact site staff by submitting a support request »

change language of formulas in Excel






Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »