Converting commas to dots in Excel 2003
Autor de la hebra: Mervyn Henderson

Mervyn Henderson  Identity Verified
España
Local time: 17:17
español al inglés
+ ...
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: 17:17
alemán
+ ...
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: 17:17
alemán al inglés
+ ...
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: 20:17
Miembro 2004
inglés al armenio
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: 21:47
inglés
+ ...
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/e
... See more
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
Collapse


 

Mervyn Henderson  Identity Verified
España
Local time: 17:17
español al inglés
+ ...
PERSONA QUE INICIÓ LA HEBRA
Great Nov 6, 2008

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


Mervyn


 

Mervyn Henderson  Identity Verified
España
Local time: 17:17
español al inglés
+ ...
PERSONA QUE INICIÓ LA HEBRA
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






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 »
SDL Trados Business Manager Lite
Create customer quotes and invoices from within SDL Trados Studio

SDL Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »



Forums
  • All of ProZ.com
  • Búsqueda de términos
  • Trabajos
  • Foros
  • Multiple search