LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing Data problem Testing Excel Discussion (Misc queries) 4 March 12th 07 12:56 PM
Problem Importing Fixed Width Data [email protected] New Users to Excel 7 September 15th 06 01:42 AM
Importing data to column from column with differnet names bey12 Excel Discussion (Misc queries) 1 August 4th 06 12:39 AM
Problem importing data from Access BT Connect Excel Discussion (Misc queries) 2 January 21st 06 04:07 PM
Problem importing external data Teresa Robinson New Users to Excel 0 October 13th 05 09:08 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"