Excel problem - localising commas and full stops
Thread poster: Sheila Hardie

Sheila Hardie  Identity Verified
Spain
Local time: 21:16
Member
Catalan to English
+ ...
Aug 10, 2003

I wonder if any Excel experts out there on this hot and sticky Sunday who can help me. I am translating text (from Spanish into English) in Excel tables full of figures. In theory, I have to change all the commas and full stops too - i.e. 6,93% to 6.93% etc. However, I just can't seem to do it - Excel won't let me:-( Does anyone know how this can be done without beginning the whole table again from start?

Many thanks for any ideas:-)


Sheila


Direct link Reply with quote
 

Eva Blanar  Identity Verified
Hungary
Local time: 21:16
English to Hungarian
+ ...
Change the Cell Format Aug 10, 2003

Select the portion you want to change into a given format (such as date, percentage). The path must be something like Format > Cells > Number: there you select the format (there is an option of individual formatting, at the end of the list).

If you see formats with an asterisk (*) on the left-hand side of the denomination, it means that the format will automatically change, subject to the OS of the computer on which the file is opened. At any rate, I'd change the format, if I were you.

[Edited at 2003-08-10 17:39]


Direct link Reply with quote
 

Sheila Hardie  Identity Verified
Spain
Local time: 21:16
Member
Catalan to English
+ ...
TOPIC STARTER
Thanks, Eva! Aug 10, 2003

Eva Blanar wrote:

Select the portion you want to change into a given format (such as date, percentage). The path must be something like Format > Cells > Number: there you select the format (there is an option of individual formatting, at the end of the list).

If you see formats with an asterisk (*) on the left-hand side of the denomination, it means that the format will automatically change, subject to the OS of the computer on which the file is opened. At any rate, I'd change the format, if I were you.

[Edited at 2003-08-10 17:39]



Thanks, Eva. I tried to do as you suggested, but it just doesn't appear to work. I have a Spanish version of Excel (Microsoft 98 for Mac) and it doesn't seem to give me the option of changing these parameters. I did go to an option (FORMATO -> CELDAS -> PERSONALIZADA) where you can choose individual formats ('personalizada' in Spanish) but couldn't find any to change the decimals commas and full stops. Maybe it's simply not possible with my version of Excel:-(

Thank you anyway for your help:-)

Sheila


Direct link Reply with quote
 
Robert Zawadzki  Identity Verified
Local time: 21:16
English to Polish
+ ...
Windows setting Aug 10, 2003

The separator is set in Start/Settings/Control panel/Regional settings (or something like that, I have Polish version of Windows). Maybe that will solve your problem.

Direct link Reply with quote
 
agtranslat
Netherlands
Local time: 21:16
Dutch to Spanish
+ ...
You may have to change the decimal symbol in the country settings Aug 10, 2003



[Edited at 2003-08-10 19:43]


Direct link Reply with quote
 

Csaba Ban  Identity Verified
Hungary
Local time: 21:16
Member (2002)
English to Hungarian
+ ...
find and replace all Aug 10, 2003

If Eva's suggestion does not work for some reason, you can always Find and Replace all occurrences of commas, etc. Select the range of cells where you want to convert commas into full stops, or change the thousand separators, etc.
Select Find / Replace from the View menu, and there you go...


Direct link Reply with quote
 

Sheila Hardie  Identity Verified
Spain
Local time: 21:16
Member
Catalan to English
+ ...
TOPIC STARTER
Any idea where to find the country settings? Aug 10, 2003

agtranslat wrote:





[Edited at 2003-08-10 19:43]


Thanks for all the ideas. I have just about given up - I've got hundreds of tables and thousands of figures and am slowly going mad here. I'm afraid can't find where the country settings are((

I think I'll contact the client tomorrow and see what they advise.

Thanks again for all your help:-)

sheila


Direct link Reply with quote
 
agtranslat
Netherlands
Local time: 21:16
Dutch to Spanish
+ ...
getting to your country settings Aug 10, 2003

Simply replacing the commas wil not work, because Excel will not recognize the periods as decimal separators.
To access you contry settings:
*click once on Start or press the Windows key
*the initial menu appears. Select Settings
*a new window should appear with a list of the things you can set (mouse, modem, etc.). It is here that you will find the country settings. (or Regional settings). Open it
*A box "Regional settings configuration" appears. Click on the tab number
*In the fold down menu for decimal separator select period. Click OK.

Go back to your Excel sheet. It could be that it now appears scrambled to the eye. Never mind. Just apply Replace all for the whole sheet. The original should reappear, but with the new decimal separator.

Caveat: If the sheet contains figures in the Spanish notation (1.234,56) get rid or the period before doing all of the above.

Mail me if you need more help.



[Edited at 2003-08-10 19:43][/quote]

Thanks for all the ideas. I have just about given up - I've got hundreds of tables and thousands of figures and am slowly going mad here. I'm afraid can't find where the country settings are((

I think I'll contact the client tomorrow and see what they advise.

Thanks again for all your help:-)

sheila[/quote]


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 »

Excel problem - localising commas and full stops

Advanced search






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



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