View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rolf Barbakken[_2_] Rolf Barbakken[_2_] is offline
external usenet poster
 
Posts: 6
Default Importing data. Problem with datatype in column

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