Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Numeric data being ignored
I have a excel file with data that i import to other excel
files. Im doning this by using the querytable object. The problem is that the source file contains text & numeric data in one column. When this is imported onto the new file, the numeric data is missing. How can i force excel to treat the numbers as text. The import is a part of a series of automated processes & i need to achieve this progarmatically. Thanks! - Anu. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numeric data with restriction of data length | Excel Discussion (Misc queries) | |||
Find and Return Numeric Label based on (Numeric Value) Criterion | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions |