numbers as text in Excel
Thread poster: Steven F Smith

Steven F Smith
United Kingdom
Local time: 07:51
Member (2007)
Japanese to English
Dec 5, 2006

Hello,
I have a large Excel file (230 worksheets, 300 000 numbers) to translate using Trados. Unfortunately all the numbers are formatted as text, so Trados doesn't just process them automatically. If I reformat the numbers as numbers in Excel (so that Trados ignores them) alot of them become negative and lose their brackets. This wouldn't be a problem if, after they've gone through Trados, I could restore their original values and brackets by reformatting them as text, but this doesn't seem to work.
I'm using Excel 2003 by the way.
If anyone has any ideas I'd be glad to hear them.
Thanks

Steven Smith


 

Jerzy Czopik  Identity Verified
Germany
Local time: 08:51
Member (2003)
Polish to German
+ ...
Are those numbers in spearate columns? Dec 5, 2006

If so, you can hide them.
To do so, select the corresponding colum, right click on it and select "Hide". Trados will then ignore the whole column.
After you´re finished, unhide the column(s).

Kind regards
Jerzy


 

Steven F Smith
United Kingdom
Local time: 07:51
Member (2007)
Japanese to English
TOPIC STARTER
Thanks for your tip Dec 5, 2006

It will be useful for future reference, but in this case there's quite a lot of text above the columns so I don't think it would work. I'm probably just going to cut the numbers pre Trados and then paste them back after translating. This will be a bit tedious but I'm not too pushed for time.

Steven


 

Tony M
France
Local time: 08:51
Member
French to English
+ ...
May depend WHY they are formatted like that? Dec 5, 2006

The use of brackets to indicate a negative quantity is one of the options for number formats (under 'Accounting', I think, though my own version is in FR!)

So if ALL the numbers are affected, you could presumably 'select all' (if you're lucky!) and set the format to number, accounting (or whatever other special format you need; you can customize them...)

In theory at least, this should not affect other cells containing only text (unless some of them have special formatting applied...)


 

Khalid Nasir
Iraq
Local time: 09:51
English to Arabic
+ ...
use function Dec 6, 2006

if you have your number formated as text in cell A2 then you can have a numer in cell b2 by using this formula "=LEFT(RIGHT(A2,LEN(A2)-1),LEN(RIGHT(A2,LEN(A2)-1))-1)" , tell if this solves your problem

 

Marta Fernandez-Suarez (X)  Identity Verified
United Kingdom
Local time: 07:51
English to Spanish
copy source Dec 6, 2006

Hi Steven

Probably I am about to state the obvious, but anyway. If you cannot use Jerzy's option and your segment consists in just a number, you do not need to do copy-paste, you can just do "copy-source" (Alt+insert), it takes a second.

There is another solution, but I do not know how to do it. There is an option in Trados to define something you do not want translated as "untranslatable text".

Regards,

Marta

[Edited at 2006-12-06 12:08]


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

numbers as text in Excel

Advanced search






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



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