Mobile menu

numbers as text in Excel
Thread poster: Steven F Smith
Steven F Smith
United Kingdom
Local time: 22:06
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


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 23:06
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


Direct link Reply with quote
 
Steven F Smith
United Kingdom
Local time: 22:06
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


Direct link Reply with quote
 

Tony M  Identity Verified
France
Local time: 23:06
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...)


Direct link Reply with quote
 

Khalid Nasir
Iraq
Local time: 01:06
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

Direct link Reply with quote
 
Marta Fernandez-Suarez  Identity Verified
United Kingdom
Local time: 22:06
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]


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 »

numbers as text in Excel

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

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



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