Extra comma in libreoffice exported file

Added by Björn Johansson almost 8 years ago

Hi,
thanks for a fantastic piece of software!
I have a small problem with the exported libreoffice file.
The student number has an extra citation character in the beginning (see attached image).

It is easy to solve, I just copy the column to a text editor and paste it back and it disappears.

But I am curious as to why this appears in the first place, and if I can get rid of it?

thanks,
Bjorn

xtra.png - screenshot showing extra character (391.9 kB)


Replies (1)

RE: Extra comma in libreoffice exported file - Added by Alexis Bienvenüe almost 8 years ago

The displayed '76495 (instead of 76495) means that the cell content is a string (and not a number), but the content is the same.
Do you need numbers instead?

(1-1/1)