Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Problem converting Excel to CSV file

  1. #1
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Problem converting Excel to CSV file

    Hi,

    I am trying to convert an Excel file that someone sent me in an email to
    a .CSV file. Two of the columns in the excel file are numeric and can be up
    to 65 characters long. When I do the File - Save As, I get the .CSV file, but those two columns are now in exponential format.

    How can I prevent that from happening when converting the file?

    Thanks,

    Nancy

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

    Format the cells as Text before entering the numbers.

  3. #3
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    I saved the .xls file and changed the format for those two columns to text.
    I then got out of excel and came back in and did the Save As over again.

    I opened up the .csv file and still had the same problem. It converted it to Exponential.

    Nancy

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default

    It's not the csv file that contains the exponential numbers, but Excel converting it when it's opened.

    The solution is to save as a txt file. Then you will get the Text Import wizard when you open it in Excel, and at step 3 you can specify that the format of those two columns is Text.

    You can test this by renaming your existing text file so that it has a txt extension.

  5. #5
    Board Regular HunterN's Avatar
    Join Date
    Mar 2002
    Location
    Maryland
    Posts
    479
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Andrew,

    That fixed the problem.

    Nancy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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