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

Jørgen Madsen  Identity Verified
Local time: 11:46
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: 11:46
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: 11:46
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: 11:46
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: 05:46
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






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
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 »



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