Results 1 to 3 of 3

Thread: Excel won't leave my data alone!

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Bronze Member
    Join Date
    Dec 2002
    Location
    Derbyshire, England
    Posts
    98

    Excel won't leave my data alone!

    This has got to be simple but I can't see the answer!

    I've got a csv file which I'm, opening in Excel. It's just a lot of text fields, i.e. "xxx","yyy","zzz",....

    Some of the fields contain data such as "1/2" but when Excel opens this file, it knows best and converts it into a date, 01-Feb.

    How do I stop it doing this?

  2. #2
    Precision Processor Super Moderator egghead's Avatar
    Join Date
    May 2002
    Location
    In Your Monitor
    Posts
    3,212
    you need to select your cells, right click choose format cells and change the format from date to numbers or similar
    ------------------------------------------------------------



  3. #3
    Bronze Member
    Join Date
    Dec 2002
    Location
    Derbyshire, England
    Posts
    98
    Trouble is that the 'open' has already converted a text string '1/2' into a date so telling it that it's a string now just shows something like '38214'!

Posting Permissions

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