Results 1 to 4 of 4

Reading Numbers as Strings from .csv file

Threaded View

  1. #1
    Registered User
    Join Date
    01-07-2010
    Location
    Alexandria, VA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Reading Numbers as Strings from .csv file

    I have a .csv file that contains numerical data in the form of strings, much of which starts with leading zeros (i.e. "012345"). I double checked to make sure the .csv file has the leading zeros and that they are wrapped in quotation marks in notepad, and it does. However, when Excel opens the file, it must read those strings as numbers, becuase it chops off the zeros. Does anyone know of way to fix this? Can Excel read numbers as strings straight from a .csv file?
    Last edited by andrewlong; 01-08-2010 at 12:25 PM.

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