Displaying numbers and text

This topic is locked

Displaying numbers and text	1/21/2004 10:32:45 PM
ASPRunnerPro General questions
G gramsw author Hi, I use ASP runner to query an Excel file directly. While displaying the search results, I notice that anything that is in a NUMERIC/ NUMBER format in the excel sheet does not get displayed For example, if I have 12345 in the Excel, it does not show up on the list page However, if i change the format to 'TEXT' in Excel then the 12345 shows up in the list page How can I show both text and numbers in the list page Thanks


	Sergey Kornilov admin 1/30/2004
	Hi, I cannot tell why it's happening. Apparently Excel returns different values when field format is NUMERIC vs TEXT. I won't recommend to use Excel as a database source because it's unstable and has many limitations. You always can import data into MS Access and use it as a datasource. It will save a lot of time in the future.