Import numbers into OpenOffice

Asked by Luis M.Jacinto on 2010-09-21

I import tables with numbers to be calculated on this form 133 709 398, 33 164 605 and 097 001 which represents 133,709,398 - 33,164,605 - 97,001 as are shown the figures have spaces, so I have to edit and delete the spaces one by one until I get a calculated figure.
Is there way that I can do this automatic?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Nic Knox
Solved:
2010-12-22
Last query:
2010-12-22
Last reply:
2010-10-23

You can format the cells so that the seperating character is a space instead of a comma

Simples

Luis M.Jacinto (ljacinto) said : #2

I am sorry it dint work, a copy of the table from OpenOffice follow s for you to have a better idea.

Thank you

1 370 572 16 536 555
1 103 234 14 504 132
1 786 959 19 170 066
529 879 1 862 504
1 680 687 64 053 913
1 326 700 5 418 743
3 391 084 25 895 519
3 227 054 35 034 128
1 854 671 25 725 772
592 814 6 673 778

Luis M.Jacinto (ljacinto) said : #3

I am sorry after I send the comment I notice a mistake
CORRECTION:

  One set Second set
1 370 572 16 536 555
1 103 234 14 504 132
1 786 959 19 170 066
529 879 1 862 504
1 680 687 64 053 913
1 326 700 5 418 743
3 391 084 25 895 519
3 227 054 35 034 128
1 854 671 25 725 772
592 814 6 673 778

Best Nic Knox (baknox) said : #4

Maybe I have misunderstood the problem, but if you want to get rid of the spaces and convert the data to a single number:
Highlight all the cells you want to convert.
Press Ctrl+F.
In 'Search for' insert a space [tap spacebar once]
leave 'Replace with' blank
tap 'Replace all'
You should find the spaces disappear and the data in each cell becomes a large number.

Luis M.Jacinto (ljacinto) said : #5

Thanks Nic Knox, that solved my question.