vcf to csv question
Results 1 to 2 of 2

Thread: vcf to csv question

  1. #1
    Join Date
    Jun 2000
    Location
    California
    Posts
    3,600

    vcf to csv question

    I've got a vcf and an identical file as csv but when I look at the data in Excel, instead of phone numbers I've got formulas.

    How do I fix that?

    Thanks - rev

  2. #2
    Join Date
    Feb 2000
    Location
    Idaho Falls, Idaho, USA
    Posts
    15,850
    Chances are the .csv file does not have quotes around the phone number field(s). There are 2 ways to fix this:

    1. Add the quotes to the .csv fields, using Notepad or some other method.

    2. Make a copy of the .csv file and change the extension of the copy to .txt, then open the .txt copy in Excel and go through the dialog to import text files, and change the format for the fields that are text from General to Text.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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