Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: formating excel data

    Hello,

    I need a way to format an Excel file while I am saving it. For example, if I have Excel Spreadsheet as:

    Code:
        ID      Name   State      AreaCode
        ===  ====   ====   ========
        1         Bob       NY         212
        2         Joe        NJ         908

    Once I would save this file as *csv I need it to look like this

    Code:
        1,'Bob','NY',212
        2,'Joe','NJ',908

    Another words I need to be able to mark columns as either Numeric or Text and save them accordingly .Is there anyway to accomplish this in Excel?

    thanks,
    webtekie

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    If you want comma separated, then save as txt file rather than csv.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    If I save as txt file becomes tab delimited w/o commas.
    Last edited by webtekie; 04-05-04 at 15:51.

  4. #4
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Saving the data illustrated as a *.CVS does what is says on the tin, ie saves it as a 'comma separated variable' file (if you open in in a word processor like notepad), at least it does on my computer!

    MTB

Posting Permissions

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