Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 04 Oct 2012 01:47:12 +0200large numbers truncated in Calchttps://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/I have a csv file where large numbers are stored. When I open the file in Calc, it somehow alters the numbers so that the trailing 7 digits are replaced by 0's. For example, 9400111201080133911953 shows up in Calc as 9400111201080130000000. how can I fix this?
thanks,
franc
Wed, 03 Oct 2012 20:29:26 +0200https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/Answer by m.a.riosv for <p>I have a csv file where large numbers are stored. When I open the file in Calc, it somehow alters the numbers so that the trailing 7 digits are replaced by 0's. For example, 9400111201080133911953 shows up in Calc as 9400111201080130000000. how can I fix this?</p>
<p>thanks,
franc</p>
https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/?answer=6550#post-id-6550In the import window, click the column head to select it, and after select Text in the Column type.
![image description](/upfiles/13492999439899366.png)Wed, 03 Oct 2012 23:34:18 +0200https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/?answer=6550#post-id-6550Comment by w_whalley for <p>In the import window, click the column head to select it, and after select Text in the Column type.</p>
<p><img alt="image description" src="/upfiles/13492999439899366.png"></p>
https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/?comment=6552#post-id-6552Better than my answerThu, 04 Oct 2012 01:47:12 +0200https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/?comment=6552#post-id-6552Answer by w_whalley for <p>I have a csv file where large numbers are stored. When I open the file in Calc, it somehow alters the numbers so that the trailing 7 digits are replaced by 0's. For example, 9400111201080133911953 shows up in Calc as 9400111201080130000000. how can I fix this?</p>
<p>thanks,
franc</p>
https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/?answer=6547#post-id-6547LibreOffice is recognizing the string 9400111201080133911953 as a number, but has insufficient precision to represent this number. If you can arrange to have your csv string be quoted, "9400111201080133911953", and choose the Quoted Field as Text option when the CSV is imported, it will display all the digits in the string. Alternatively you could prepend a ' to the string in the CSV, i.e. '9400111201080133911953, it will be recognized as text. Wed, 03 Oct 2012 21:29:08 +0200https://ask.libreoffice.org/en/question/6546/large-numbers-truncated-in-calc/?answer=6547#post-id-6547