Mobile menu

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

Mervyn Henderson  Identity Verified
Spain
Local time: 18:45
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


Direct link Reply with quote
 

tectranslate ITS GmbH
Local time: 18:45
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]


Direct link Reply with quote
 
Ken Cox  Identity Verified
Local time: 18:45
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'.


Direct link Reply with quote
 

Henrik Pipoyan  Identity Verified
Local time: 20:45
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.


Direct link Reply with quote
 
sureshkumar84
India
Local time: 22:15
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


Direct link Reply with quote
 

Mervyn Henderson  Identity Verified
Spain
Local time: 18:45
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


Direct link Reply with quote
 

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

Brilliant. Tools - Options - International.

Thanks a lot again - it was embarrassingly easy.


Mervyn


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 »

Converting commas to dots in Excel 2003

Advanced search






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



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