Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to import a text file to Excel treating all input content are in string.
Hi All,
I would like to share my excel problem, please help me out. I want to load a text file which contains string and floating values, but the floating values are getting affected by the regional settings. So I need excel should treat all column inputs as string. For example: "6.000" = 6.000 Here if Digit Grouing Symbol set as '.', then my output looks some thing like 600.000 Thanks in advance Chittu |
#2
|
|||
|
|||
In Addition:
The number of cell is not known, it may go upto 256, when I was trying to set the individual 'FieldInfo' to 'xlTextFormat' of all 256 cell, VB is not allowing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
Is there a way to import a pdf file in to Excel | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
How To Import Text File With No Delimiters? | Excel Discussion (Misc queries) |