Ubuntu
openoffice.org package

Import numbers into OpenOffice

Asked by Luis M.Jacinto

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:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

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

Simples

Revision history for this message
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

Revision history for this message
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

Revision history for this message
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.

Revision history for this message
Luis M.Jacinto (ljacinto) said : 		#5

Thanks Nic Knox, that solved my question.