https://bugs.freedesktop.org/show_bug.cgi?id=81935
--- Comment #8 from Algot Runeman <[email protected]> --- During import, If, under "Other Options", you remove the checkmark from "Quoted field as text", the data in column J imports as a number instead of text. The use of single quote "ticks" to force numbers to text is a common practice (think zip code entry to prevent loss of leading zeros). If the conversion must be done after the import, it is common to add another column (say between J and K) and then insert the function =value(J2) into the new column, duplicating as needed. This article might have some bearing. There's a format code of the at symbol @ which is invoked in the cells of column C. https://help.libreoffice.org/Common/Number_Format_Codes I did see the odd result of =sum(c2:c7) being equal to zero while =c2+c3+c4+c5+c6+c7 gave a value of 79647. The inconsistency is odd. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
