On 26 Feb., 12:54, "Rolf Barbakken" wrote:
Hi

I'm importing data from a webpage. All data comes into the spreadsheet, and
most is fine, but I have a column for "status" that contains one or more
single-digit numbers. If what is imported is "1.2" (two statuses), Excel
interprets it as a date (1. February). If I change the datatype of the
column after import to Text I get the datevalue (39845).

How can I avoid this problem? Is it possible to force Excel just to leave
the data alone as it is and not interpret it?

I cannot change what's in the webpage or the database it is generated from.

Any help appreciated.

- Rolf

Is it possible to format e.g. the rows to the number format before you
import the data? That sometimes helps me

/Kasper