Mobile menu

€€€€€ - Getting these little guys to the left in MS-Word
Thread poster: Edward Potter

Edward Potter  Identity Verified
Spain
Local time: 06:39
Member (2003)
Spanish to English
+ ...
Dec 28, 2007

Does anyone have a good workaround for getting those pesky little euro signs from the right side of my numbers to the left side?

Example:

I want this list

55.33 €
23.99 €
46.59 €
78.21 €

to look like this list

€55.33
€23.99
€46.59
€78.21

with only 3 clicks.

How can I do this?


Direct link Reply with quote
 
Margreet Logmans  Identity Verified
Netherlands
Local time: 06:39
English to Dutch
+ ...
Type them? Dec 28, 2007

How did you make that first list in the first place?

Direct link Reply with quote
 

Claudia Alvis  Identity Verified
Peru
Local time: 23:39
Partial member
Spanish
+ ...
Find/Replace with Wildcards Dec 28, 2007

You could do a Find/Replace with wildcards. Use:

Find what:
([0-9][0-9]).([0-9][0-9]) €

Replace with:
€\1.\2

Make sure 'Use Wildcards' is checked. That is if all your numbers have the same format, if not, you can modify it a bit. That should work.

[0-9] Represents any digit
\1 represents what's in the first bracket, which is ([0-9][0-9])
\2 represents what's in the second one.

Good luck


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 06:39
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
Type them Dec 28, 2007

Hi Margreet.

Thank you for your reply. But, do you see where I am coming from here? What do I do when I have 2000 numbers on my list? Type them?


Direct link Reply with quote
 

Renée van Bijsterveld  Identity Verified
Netherlands
Local time: 06:39
Member (2007)
English to Dutch
+ ...
Create a table Dec 28, 2007

If it's a long list I would convert the list to a table (two columns), with the numbers in one column and the euro sign in the next. Then you can cut the euro column and paste it on the left side.

Or you could import/copy the amounts into an Excel table, delete the euro sign, and reformat the amounts to show the currency sign.
Good luck,
Renée


Direct link Reply with quote
 

Edward Potter  Identity Verified
Spain
Local time: 06:39
Member (2003)
Spanish to English
+ ...
TOPIC STARTER
Wildcards Dec 28, 2007

Aha! That is what I was looking for! Thank you!

Direct link Reply with quote
 
Margreet Logmans  Identity Verified
Netherlands
Local time: 06:39
English to Dutch
+ ...
No, but.... Dec 28, 2007

This ís Word, we're talking about, right?
How did you make your original list? I assume you're looking for an automated setting, but I don't understand which setting you used in your first list.

In Excel, this would be easy. RenéevB's suggestion is workable.

Did you copy and paste the numbers froms somewhere else? Or did you get it like this from a client?

I didn't mean to be unfriendly, I meant to say you needed to give a little more information about this. Sorry if it didn't come across like that.

Margreet

[Edited at 2007-12-28 15:59]


Direct link Reply with quote
 

Lesley Clarke  Identity Verified
Mexico
Local time: 23:39
Spanish to English
Thanks Dec 28, 2007

Thanks to Edward for asking the question and Claudia for answering it, you've made my day.

I see this can also be adapted for that horrible decimal comma. Wonderful!


Direct link Reply with quote
 

Sylvain Leray  Identity Verified
Local time: 06:39
Member (2003)
German to French
CAT-tool ? Dec 28, 2007

Edward, do you use a CAT-tool ? If yes, "translate" the first row and apply your translation to the other rows automatically, and it should do the trick.

Sylvain


Direct link Reply with quote
 

Boris Sigalov
Local time: 07:39
English to Russian
Wildcards Dec 28, 2007

Claudia Alvis wrote:

You could do a Find/Replace with wildcards.


Very interesting and really useful technique, Claudia! Could you recommend a place in the internet where I can read how to create wildcards for various Find/Replace purposes?


Direct link Reply with quote
 

Claudia Alvis  Identity Verified
Peru
Local time: 23:39
Partial member
Spanish
+ ...
Website Dec 28, 2007

I haven't read it thoroughly though.

http://word.mvps.org/FAQs/General/UsingWildcards.htm


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 »

€€€€€ - Getting these little guys to the left in MS-Word

Advanced search






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 »
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