Changing the decimal point in amounts in Excel
Thread poster: Jørgen Madsen

Jørgen Madsen  Identity Verified
Local time: 19:33
English to Danish
+ ...
May 31, 2005

I use MS Excel to create invoices. My (Danish) version of the program uses comma as decimal point and full stop as thousands separator, which is consistent with Danish spelling rules.
How can I reverse this (viz. use full stop as decimal point and comma as thousands separator) to show amounts according to English spelling rules?
Do I really need an English version of Excel?

Please, no suggestions for using other programs or other comments not directly answering my question.

TIA Jørgen


 

Natalie  Identity Verified
Poland
Local time: 19:33
Member (2002)
English to Russian
+ ...

MODERATOR
Hi Jorgen May 31, 2005

As far as I remember, Excel acquires the options set in Windows ( Regional Settings). Just go to the control panel > Regional and Language Settings, and change the settings as needed.

HTH,
Natalia


[Edited at 2005-05-31 15:25]


 

Ralf Lemster  Identity Verified
Germany
Local time: 19:33
English to German
+ ...
Which version? May 31, 2005

Hi Jorgen,
Which Excel version are you using? Excel XP permits to change the numerical signs independently of the operating system (Tools - Options - International); I would expect Excel 2003 to do the same.

Best, Ralf


 

Jørgen Madsen  Identity Verified
Local time: 19:33
English to Danish
+ ...
TOPIC STARTER
Thanks... May 31, 2005

Hello Natalia

... I'm almost embarrassed over how easy that was.
Thanks again
icon_biggrin.gif


Natalie wrote:

As far as I remember, Excel acquires the options set in Windows ( Regional Settings). Just go to the control panel > Regional and Language Settings, and change the settings as needed.

HTH,
Natalia


 

Can Altinbay  Identity Verified
Local time: 13:33
Japanese to English
+ ...
Format>Cells May 31, 2005

Ralf Lemster wrote:

Hi Jorgen,
Which Excel version are you using? Excel XP permits to change the numerical signs independently of the operating system (Tools - Options - International); I would expect Excel 2003 to do the same.

Best, Ralf


There's a Custom option at the end of the list that includes Currency. It's been there for as long as I remember.


 


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


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

Changing the decimal point in amounts in Excel

Advanced search






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 »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search