Opening a text or CSV file in Excel

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

Thread: Opening a text or CSV file in Excel

  1. #1
    Board Regular
    Join Date
    Aug 2002
    Location
    Workcover
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Opening a text or CSV file in Excel

     
    Hi,

    I have a CSV file where one of the field's is a number field which has 17 characters/numbers in. The file when opening is substituting the last 2 digits as 00, instead of what they should be. Example is below.

    20020407080000334

    it opens in excel as

    20020407080000300

    Any suggestions would be greatly appreciated.

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    14,181
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening a text or CSV file in Excel

      
    change the file extension to txt, open from excel - you should get the 'text to cols' dialogue box. make sure you select text as the data type for the column - the prob you've got is that the string is being interpreted as a number & is falling victim to excel's 15 digit number precision limit.

    paddy

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
  •  

 

 
DMCA.com