+ Reply to Thread
Results 1 to 2 of 2

numeric data

  1. #1
    Win
    Guest

    numeric data

    i've a csv file

    001, apple
    002, fish

    when i use execl to open this file, the data in column A become 1, 2, etc.

    how can i the execl 001, 002, in column A




  2. #2
    Peo Sjoblom
    Guest

    Re: numeric data

    You can rename the file to txt and use the text import wizard there you can
    change the import format to text unless it is always 3 digits then you can
    use custom format 000



    --
    Regards,

    Peo Sjoblom

    Portland, Oregon




    "Win" <aaa@aaa.com> wrote in message
    news:eaixUkSLGHA.2912@tk2msftngp13.phx.gbl...
    > i've a csv file
    >
    > 001, apple
    > 002, fish
    >
    > when i use execl to open this file, the data in column A become 1, 2, etc.
    >
    > how can i the execl 001, 002, in column A
    >
    >
    >



+ 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