Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing Data problem | Excel Discussion (Misc queries) | |||
Problem Importing Fixed Width Data | New Users to Excel | |||
Importing data to column from column with differnet names | Excel Discussion (Misc queries) | |||
Problem importing data from Access | Excel Discussion (Misc queries) | |||
Problem importing external data | New Users to Excel |