formating excel data

webtekie · #1 (**permalink**) 04-05-04, 13:15

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

shades · #2 (**permalink**) 04-05-04, 14:08

If you want comma separated, then save as txt file rather than csv.

webtekie · #3 (**permalink**) 04-05-04, 14:41

If I save as txt file becomes tab delimited w/o commas.

MikeTheBike · #4 (**permalink**) 04-06-04, 08:08

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

Internet Services

Web Development

Digital Marketing

Consumer Tech