Mobile menu

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

Mervyn Henderson  Identity Verified
Spain
Local time: 23:00
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: 23:00
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: 23:00
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: 01:00
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: 02:30
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: 23:00
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: 23:00
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






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



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