+ Reply to Thread
Results 1 to 7 of 7

csv file import

Hybrid View

  1. #1
    d_kight
    Guest

    csv file import

    I have tried and succeeded in importing a .csv file into excel. This file has
    numerical values. After converting the file, I try and add a few of the
    numbers in one of the colunms and my answer is always #VALUE; which tells me
    those numbers are being read as values and not numbers. HOW do I import the
    file or what changes do I need to make in order to get those numbers to be
    seen as Numerical after the file is imported?

  2. #2
    Gail
    Guest

    Re: csv file import

    If you can change the name of the file you are importing into excel to one
    ending in .txt you will get the import wizard open and that will allow you
    to change formatting for columns.

    If this is not a solution, there is an Add-in available (free) called ASAP
    Utilities that can help in changing the numbers to actual numbers rather
    than text

    "d_kight" <dkight@discussions.microsoft.com> wrote in message
    news:FC43566F-D4AB-4AD6-B99B-76808015BCFE@microsoft.com...
    >I have tried and succeeded in importing a .csv file into excel. This file
    >has
    > numerical values. After converting the file, I try and add a few of the
    > numbers in one of the colunms and my answer is always #VALUE; which tells
    > me
    > those numbers are being read as values and not numbers. HOW do I import
    > the
    > file or what changes do I need to make in order to get those numbers to be
    > seen as Numerical after the file is imported?




  3. #3
    d_kight
    Guest

    Re: csv file import

    thanks Gail, However, the import wizard seems to work fine coming form a .csv
    file going to a .xl file (or so it seems). Are you suggesting that I re-save
    the .csv file as a .txt file THEN use the Import wizard in Excel?

    "Gail" wrote:

    > If you can change the name of the file you are importing into excel to one
    > ending in .txt you will get the import wizard open and that will allow you
    > to change formatting for columns.
    >
    > If this is not a solution, there is an Add-in available (free) called ASAP
    > Utilities that can help in changing the numbers to actual numbers rather
    > than text
    >
    > "d_kight" <dkight@discussions.microsoft.com> wrote in message
    > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE@microsoft.com...
    > >I have tried and succeeded in importing a .csv file into excel. This file
    > >has
    > > numerical values. After converting the file, I try and add a few of the
    > > numbers in one of the colunms and my answer is always #VALUE; which tells
    > > me
    > > those numbers are being read as values and not numbers. HOW do I import
    > > the
    > > file or what changes do I need to make in order to get those numbers to be
    > > seen as Numerical after the file is imported?

    >
    >
    >


  4. #4
    JLatham
    Guest

    Re: csv file import

    Try this method? I think step 3 of this wizard is where you will find a
    solution.
    From the menu bar
    Data | Import External Data | Import Data
    When the open file window comes up, choose File Types with the .csv entry in
    it. Continue on and identify your file and then the Wizard gets started for
    real. Make sure that you set things along the way, like the separator
    itself. In Step 3 of 3 make sure that all columns are set to "General" type.
    That should import numbers as numbers, text as text, dates as dates, etc.

    Before you start you might want to select all the cells on your worksheet
    and use Edit | Clear | Format
    to make sure that the cells/columns on it are not formatted as Text. I'm
    not certain if the choice made with the data import wizard overrides any
    formatting already on a sheet or not right at this moment.

    "d_kight" wrote:

    > thanks Gail, However, the import wizard seems to work fine coming form a .csv
    > file going to a .xl file (or so it seems). Are you suggesting that I re-save
    > the .csv file as a .txt file THEN use the Import wizard in Excel?
    >
    > "Gail" wrote:
    >
    > > If you can change the name of the file you are importing into excel to one
    > > ending in .txt you will get the import wizard open and that will allow you
    > > to change formatting for columns.
    > >
    > > If this is not a solution, there is an Add-in available (free) called ASAP
    > > Utilities that can help in changing the numbers to actual numbers rather
    > > than text
    > >
    > > "d_kight" <dkight@discussions.microsoft.com> wrote in message
    > > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE@microsoft.com...
    > > >I have tried and succeeded in importing a .csv file into excel. This file
    > > >has
    > > > numerical values. After converting the file, I try and add a few of the
    > > > numbers in one of the colunms and my answer is always #VALUE; which tells
    > > > me
    > > > those numbers are being read as values and not numbers. HOW do I import
    > > > the
    > > > file or what changes do I need to make in order to get those numbers to be
    > > > seen as Numerical after the file is imported?

    > >
    > >
    > >


  5. #5
    d_kight
    Guest

    Re: csv file import

    Thanks Latham, I will definitely give that a go! and Steve, the format is in
    ..csv. Is that what you are refering to?

    "JLatham" wrote:

    > Try this method? I think step 3 of this wizard is where you will find a
    > solution.
    > From the menu bar
    > Data | Import External Data | Import Data
    > When the open file window comes up, choose File Types with the .csv entry in
    > it. Continue on and identify your file and then the Wizard gets started for
    > real. Make sure that you set things along the way, like the separator
    > itself. In Step 3 of 3 make sure that all columns are set to "General" type.
    > That should import numbers as numbers, text as text, dates as dates, etc.
    >
    > Before you start you might want to select all the cells on your worksheet
    > and use Edit | Clear | Format
    > to make sure that the cells/columns on it are not formatted as Text. I'm
    > not certain if the choice made with the data import wizard overrides any
    > formatting already on a sheet or not right at this moment.
    >
    > "d_kight" wrote:
    >
    > > thanks Gail, However, the import wizard seems to work fine coming form a .csv
    > > file going to a .xl file (or so it seems). Are you suggesting that I re-save
    > > the .csv file as a .txt file THEN use the Import wizard in Excel?
    > >
    > > "Gail" wrote:
    > >
    > > > If you can change the name of the file you are importing into excel to one
    > > > ending in .txt you will get the import wizard open and that will allow you
    > > > to change formatting for columns.
    > > >
    > > > If this is not a solution, there is an Add-in available (free) called ASAP
    > > > Utilities that can help in changing the numbers to actual numbers rather
    > > > than text
    > > >
    > > > "d_kight" <dkight@discussions.microsoft.com> wrote in message
    > > > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE@microsoft.com...
    > > > >I have tried and succeeded in importing a .csv file into excel. This file
    > > > >has
    > > > > numerical values. After converting the file, I try and add a few of the
    > > > > numbers in one of the colunms and my answer is always #VALUE; which tells
    > > > > me
    > > > > those numbers are being read as values and not numbers. HOW do I import
    > > > > the
    > > > > file or what changes do I need to make in order to get those numbers to be
    > > > > seen as Numerical after the file is imported?
    > > >
    > > >
    > > >


  6. #6
    d_kight
    Guest

    Re: csv file import

    JLatham,
    I did everything that you suggested and I tried to add a couple of simple
    numbers. I continue to come up with #VALUE!.
    Is there something I am missing?

    D_Kight

    "JLatham" wrote:

    > Try this method? I think step 3 of this wizard is where you will find a
    > solution.
    > From the menu bar
    > Data | Import External Data | Import Data
    > When the open file window comes up, choose File Types with the .csv entry in
    > it. Continue on and identify your file and then the Wizard gets started for
    > real. Make sure that you set things along the way, like the separator
    > itself. In Step 3 of 3 make sure that all columns are set to "General" type.
    > That should import numbers as numbers, text as text, dates as dates, etc.
    >
    > Before you start you might want to select all the cells on your worksheet
    > and use Edit | Clear | Format
    > to make sure that the cells/columns on it are not formatted as Text. I'm
    > not certain if the choice made with the data import wizard overrides any
    > formatting already on a sheet or not right at this moment.
    >
    > "d_kight" wrote:
    >
    > > thanks Gail, However, the import wizard seems to work fine coming form a .csv
    > > file going to a .xl file (or so it seems). Are you suggesting that I re-save
    > > the .csv file as a .txt file THEN use the Import wizard in Excel?
    > >
    > > "Gail" wrote:
    > >
    > > > If you can change the name of the file you are importing into excel to one
    > > > ending in .txt you will get the import wizard open and that will allow you
    > > > to change formatting for columns.
    > > >
    > > > If this is not a solution, there is an Add-in available (free) called ASAP
    > > > Utilities that can help in changing the numbers to actual numbers rather
    > > > than text
    > > >
    > > > "d_kight" <dkight@discussions.microsoft.com> wrote in message
    > > > news:FC43566F-D4AB-4AD6-B99B-76808015BCFE@microsoft.com...
    > > > >I have tried and succeeded in importing a .csv file into excel. This file
    > > > >has
    > > > > numerical values. After converting the file, I try and add a few of the
    > > > > numbers in one of the colunms and my answer is always #VALUE; which tells
    > > > > me
    > > > > those numbers are being read as values and not numbers. HOW do I import
    > > > > the
    > > > > file or what changes do I need to make in order to get those numbers to be
    > > > > seen as Numerical after the file is imported?
    > > >
    > > >
    > > >


  7. #7
    SteveW
    Guest

    Re: csv file import

    If it's a comma seperated file - it should load correctly.

    what format is the data ?

    and as mentioned - is it plain text

    Steve


    On Fri, 14 Jul 2006 17:41:02 +0100, d_kight =

    <dkight@discussions.microsoft.com> wrote:

    > I have tried and succeeded in importing a .csv file into excel. This =


    > file has
    > numerical values. After converting the file, I try and add a few of th=

    e
    > numbers in one of the colunms and my answer is always #VALUE; which =


    > tells me
    > those numbers are being read as values and not numbers. HOW do I impo=

    rt =

    > the
    > file or what changes do I need to make in order to get those numbers t=

    o =

    > be
    > seen as Numerical after the file is imported?


+ 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