Technical forums » Software applications »
Russian numbers in Excel
Thread poster: Chris Dawe
Chris Dawe
Chris Dawe  Identity Verified
United Kingdom
Local time: 11:44
Portuguese to English
+ ...
Feb 9, 2011

Does anyone know how I can override Russian numbering in Excel?
An example, Seventy million, in Russian > 70000000.00
In English this should read 70,000,000.
But the settings won't let me put commas in. Does anyone know how I can change this? Thanks. Chris Dawe.
 
Natalie
Natalie  Identity Verified
Poland
Local time: 12:44
Member (2002)
English to Russian
+ ...

Moderator of this forum
SITE LOCALIZER
Hi Chris Feb 9, 2011

This should be changed in Windows, in local settings.

Natalia
 
Chris Dawe
Chris Dawe  Identity Verified
United Kingdom
Local time: 11:44
Portuguese to English
+ ...
TOPIC STARTER
Windows; Local settings. Feb 9, 2011

Hi Natalia, thanks very much indeed. Do you mean from Control Panel? Merci, Chris.
 
Natalie
Natalie  Identity Verified
Poland
Local time: 12:44
Member (2002)
English to Russian
+ ...

Moderator of this forum
SITE LOCALIZER
Yes, exactly Feb 9, 2011

No need to change the country, of course, just set the necessary style for numbers.

Natalia
 
Adam Łobatiuk
Adam Łobatiuk  Identity Verified
Poland
Local time: 12:44
Member (2009)
English to Polish
+ ...
Not only Feb 9, 2011

You can also change international settings directly in Excel (and for Excel only). In Excel 2003, go to Tools, Options, International (or similar, I don't have the English version).

However, the example you gave is NOT Russian formatting (to my knowledge). Russian uses the decimal comma, not the period/full stop. So, this is only a matter of missing English thousand separators, which could still be English formatting. You can change that under Format > Cells > Numbers.
 
Chris Dawe
Chris Dawe  Identity Verified
United Kingdom
Local time: 11:44
Portuguese to English
+ ...
TOPIC STARTER
Excel 2007 Feb 9, 2011

Hi Adam, thanks very much, do you have any idea where I can find these in Excel 2007? Cheers, Chris.
 
Adam Łobatiuk
Adam Łobatiuk  Identity Verified
Poland
Local time: 12:44
Member (2009)
English to Polish
+ ...
Re: Excel 2007 Feb 9, 2011

Hi Chris,

Unfortunately, I'm still using Office 2003, but as far as the International options are concerned, you should be able to find them in the Help (good keywords could be international, separators, decimal).

To format numbers in cells, you can probably Select all, then right-click and select Format cells.

Good luck!
Adam
 
Chris Dawe
Chris Dawe  Identity Verified
United Kingdom
Local time: 11:44
Portuguese to English
+ ...
TOPIC STARTER
Select all, then right-click and select Format cells Feb 9, 2011

Thanks for getting back to me at this late hour Adam, that worked very well, you're a Star. Chris.
 


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

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

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

Russian numbers in Excel






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »