प्राविधिक फोरमहरू » Software applications »
Russian numbers in Excel
थ्रेड पोस्टर: Chris Bascand
Chris Bascand
Chris Bascand
New Zealand
Local time: 06:32
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: 18:32
सदस्य (2002)
English to Russian
+ ...

यस फोरमको मध्यस्तकर्ता
SITE LOCALIZER
Hi Chris Feb 9, 2011

This should be changed in Windows, in local settings.

Natalia
 
Chris Bascand
Chris Bascand
New Zealand
Local time: 06:32
Portuguese to English
+ ...
विषय आरम्भक
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: 18:32
सदस्य (2002)
English to Russian
+ ...

यस फोरमको मध्यस्तकर्ता
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: 18:32
सदस्य (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 Bascand
Chris Bascand
New Zealand
Local time: 06:32
Portuguese to English
+ ...
विषय आरम्भक
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: 18:32
सदस्य (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 Bascand
Chris Bascand
New Zealand
Local time: 06:32
Portuguese to English
+ ...
विषय आरम्भक
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:

यस फोरमको मध्यस्तकर्ता(हरू)
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






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 »
Pastey
Your smart companion app

Pastey is an innovative desktop application that bridges the gap between human expertise and artificial intelligence. With intuitive keyboard shortcuts, Pastey transforms your source text into AI-powered draft translations.

Find out more »