+ Reply to Thread
Results 1 to 2 of 2

How to import a text file to Excel treating all input content are in string.

  1. #1
    Chittu
    Guest

    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. #2
    Chittu
    Guest

    Re: How to import a text file to Excel treating all input content are in string.

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1