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

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


Direct link Reply with quote
 

Natalie  Identity Verified
Poland
Local time: 01:11
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]


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 01:11
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


Direct link Reply with quote
 

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

Hello Natalia

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



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


Direct link Reply with quote
 

Can Altinbay  Identity Verified
Local time: 19:11
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.


Direct link Reply with quote
 


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






SDL Trados Studio 2017 only €415 / $495
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €415 / $495 / £325 / ¥60,000 You will also receive FREE access to our getting started eLearning program!

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



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