Changing the decimal point in amounts in Excel
Thread poster: jmadsen

jmadsen  Identity Verified
Local time: 18:41
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: 18:41
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: 18:41
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
 

jmadsen  Identity Verified
Local time: 18:41
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: 12:41
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






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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