Converting commas to dots in Excel 2003
Thread poster: Mervyn Henderson

Mervyn Henderson  Identity Verified
Spain
Local time: 16:37
Member
Spanish to English
+ ...
Nov 6, 2008

Hi everyone,

I'm doing a French-English financial report in Word with incrusted Excel tables, but when I try to change the amounts in euros, say, "678,59" to "678.59", the system slots in a code such as "B=54". Does anyone know an easy way of getting round this?

TIA,


Mervyn


 

tectranslate ITS GmbH
Local time: 16:37
German
+ ...
Don't. Nov 6, 2008

That's not the way it works.

Just leave the commas and dots as they are and define the thousands and decimal separators in the Tools>Options>International dialog. Applies to the currently open document only, AFAIK.

HTH,
Benjamin

[Edited at 2008-11-06 10:19]


 

Ken Cox  Identity Verified
Local time: 16:37
German to English
+ ...
change the language setting Nov 6, 2008

Change the language setting to English. If the values were entered with a language setting for which commas are used as decimal markers, they will be converted automatically.

By the way, the English term is 'embedded tables'.


 

Henrik Pipoyan  Identity Verified
Local time: 18:37
Member (2004)
English to Armenian
Hi Mervyn, Nov 6, 2008

My Excel version is not 2003, but I think this should be the same in all versions.

On the Tools menu, click Options, and then click the International tab. Under Number Handling, clear the Use system separators check box. Type a comma in the Decimal separator box.

I hope this helps.


 

sureshkumar84
India
Local time: 20:07
English
+ ...
answer Nov 6, 2008

Sir
I didn't get it your question clearly. But I have a few solutions.
Go to tools option click add-in. Then check it the euro conversion option then install it if you not previously done. Now you may not have the problem.
If it persists go to this link

http://office.microsoft.com/en-us/excel/results.aspx?qu=change%20the%20amount%20from%20dollor%20to%20euro&sc=9&av=ZXL110


 

Mervyn Henderson  Identity Verified
Spain
Local time: 16:37
Member
Spanish to English
+ ...
TOPIC STARTER
Great Nov 6, 2008

Thanks a million, all of you. I'll have a go at it later.


Mervyn


 

Mervyn Henderson  Identity Verified
Spain
Local time: 16:37
Member
Spanish to English
+ ...
TOPIC STARTER
Aha Nov 6, 2008

Brilliant. Tools - Options - International.

Thanks a lot again - it was embarrassingly easy.


Mervyn


 


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


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

Converting commas to dots in Excel 2003

Advanced search






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, helps experienced users make the most of the powerful features, ensures new

More info »
SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »



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