I have imported tabular data into Excel and it interpreted long sequnces of figures as numbers and displayed them in scientific form:
How to tell this thing, that these are text? In previous version of Excel it was possible to format cells as text and then paste as values into the same place. In modern Excel I have formatted cells as text, but this thing still displays it in scientific form.
How to overcome?