Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 11 Sep 2019 11:44:47 +0200Make whole spreadsheet numbers with value..https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/ I have to keep Value Highlighting on in order to see if the numbers I input are actually a number my pivot table will sum up..
I constantly have to reformat my cells and use Data> Text to Column in order to get the number to be a number...
any way to default the whole spreadsheet as numbers?Tue, 10 Sep 2019 00:22:32 +0200https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/Comment by clos911 for <p>I have to keep Value Highlighting on in order to see if the numbers I input are actually a number my pivot table will sum up..
I constantly have to reformat my cells and use Data> Text to Column in order to get the number to be a number...</p>
<p>any way to default the whole spreadsheet as numbers?</p>
https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/?comment=208154#post-id-208154They are formatted as numbers, also pasting numbers that have value does will no longer have value value once pasted...Tue, 10 Sep 2019 21:45:16 +0200https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/?comment=208154#post-id-208154Comment by m.a.riosv for <p>I have to keep Value Highlighting on in order to see if the numbers I input are actually a number my pivot table will sum up..
I constantly have to reformat my cells and use Data> Text to Column in order to get the number to be a number...</p>
<p>any way to default the whole spreadsheet as numbers?</p>
https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/?comment=208095#post-id-208095Verify the cells are not formatted as text, if so maybe it happens when you import the numbers.Tue, 10 Sep 2019 11:38:37 +0200https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/?comment=208095#post-id-208095Answer by erAck for <p>I have to keep Value Highlighting on in order to see if the numbers I input are actually a number my pivot table will sum up..
I constantly have to reformat my cells and use Data> Text to Column in order to get the number to be a number...</p>
<p>any way to default the whole spreadsheet as numbers?</p>
https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/?answer=208219#post-id-208219Pasting from where (which source format) and how? If the source is HTML it might help to use Paste Special (Shift+Ctrl+V) and select Unformatted Text which uses the Text/CSV import, and if it's a table use *Space* separator and *Merge delimiters*.Wed, 11 Sep 2019 11:44:47 +0200https://ask.libreoffice.org/en/question/208053/make-whole-spreadsheet-numbers-with-value/?answer=208219#post-id-208219