Technical forums » Office applications »
change language of formulas in Excel
Thread poster: bendksu
bendksu
bendksu  Identity Verified
Thailand
Local time: 23:53
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: 23:53
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: 23:53
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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »