This question already has an answer here:
I have a question regarding Excel. We generate automatically a CSV file everyday, containing stuff looking like :
The issue is that the number 249316479917397279 is too long now to be displayed by Excel entirely. Excels shows "2,49316E+17" and even when I go edit the cell I see 249316479917397000.
The number is rounded by Excel and I lose the three last numbers, which are important for me since these numbers are IDs. I would Excel to display it as a text, without no rounding. I tried to generate my csv with quotes "249316479917397279" but dosn't change anything.
Is it possible?