var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: formating excel data
I need a way to format an Excel file while I am saving it. For example, if I have Excel Spreadsheet as:
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
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?
If you want comma separated, then save as txt file rather than csv.
If I save as txt file becomes tab delimited w/o commas.
Last edited by webtekie; 04-05-04 at
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!