Gnumeric: converting text-numerals [Solved]

[satuser083]

Does anyone know of a rapid way of converting a list of numbers in text-format (i.e. '10 '11 '12), which gnumeric clearly cannot perform a sum on, to a list of number-values (i.e. 10 11 12) which it can add together. I believe I saw a procedure some time ago, but can't find it now, of course . Thanks

[Yankee]

Does anyone know of a rapid way of converting a list of numbers in text-format (i.e. '10 '11 '12), which gnumeric clearly cannot perform a sum on, to a list of number-values (i.e. 10 11 12) which it can add together. I believe I saw a procedure some time ago, but can't find it now, of course . Thanks

They're not in the same cell are they, that is hard.   Otherwise just format them to
numeric, you should be able to search and replace any unwanted symbols.

FF

[rich2005]

If they are in individual cells as text in a column then the value(cell) function should work

[satuser083]

If they are in individual cells as text in a column then the value(cell) function should work

You've just given me an idea which led to the solution; here it is:

Code: [Select]


1. Remove currency-symbol if present (Edit -> Search and Replace -> etc)

2. Insert a new column IMMEDIATELY TO THE RIGHT of the column to be converted

3. Mark the entire column-length to be converted; then  -> Data -> Text to Columns -> Finish

4. The converted column should now be in the column IMMEDIATELY to its right; this is why it is necessary to
    insert a new column here (see 2. above), because this column's contents will be OVERWRITTEN!!!

5. Finished
Many thanks to you both  .

[jnmtjv]

You can also take an advantage of Gnumeric-function numbervalue(range,'dec.separator').